Excel formula

Occasional Visitor

i have a data set that contains one particular column filled with names in each cell. each cell has multiple names. some cells its separated by semicolon, some by colon and some are separated by new lines.

Long way to count number of names in each cell is to convert it from text to column and account for different seperation (i.e. semicolon, colon, space etc.).  Is there an easy way to count number of names on each cell?

 

0 Replies