Hi All,
I have a spreadhseet with a column that contains contact names. The cells contain multiple names (between 2 and 4 names in each cell) e.g 'Mr J Smith, Mrs A Brown, Miss J White'. I need to write a formula to extract all of the names into seperate cells.
I've managed to extract the first name using the following formula
=LEFT(text, SUM(FIND(",",text)-1))
With the above example, this would give me 'Mr J Smith'
I'm struggling to then extract the second/third/fourth names into seperate cells. Does anyone have any suggestions?
Thanks,
Tom
Bookmarks