How to pull out names from a Comma Separated list in box?

I've got a Name column that gets populated with either one name or several names separated by commas.

eg. John Smith, Michael Jones, Harry Hill

What I'd like to be able to do is have a set of columns off to the right with Name 1, Name 2, Name 3, Name 4 etc. All pulling the individual names if there is more than one. If there isn't more than name one I assume I could use an IFERROR to make it blank.


Best Answer


  • Thanks!

    I've got the first two names working, but I can't quite work out what I have to change to get the names 3 and onwards to work. Which part of the formula do I have to change?

  • I've almost got it working

    I realised I'm being really stupid just needed to drag the formula along and it auto changes to the next name. Sorted!

    Thanks for your help.

  • Matt Kirby
    Matt Kirby ✭✭✭✭

    This solution was helpful for my use case as well. Is there a way to make the formula valid for column formula usage? I get an error message when trying to apply it as a column formula.