Return existing cell value unless comma present, then return "Team"

[al8a88]

Hi All,

This is so simple but for some reason I cannot wrap my head around it.
I have a column with different task owners and need to create a separate column that summarizes any owner column data that has a comma to return word "Team", but if there's no comma, return the value that exists. Example image attached.

Thanks so much!

 

[Joe4]

Welcome to the Board!

Try this formula:

=IF(ISNUMBER(FIND(",",A2)),"Team",A2)

 

[al8a88]

Welcome to the Board!

Try this formula:

=IF(ISNUMBER(FIND(",",A2)),"Team",A2)

Thank you! That worked perfectly!

 

[Joe4]

You are welcome.
Glad I was able to help!