"Biff" wrote in message
...
Hi!

Don't know what your formulas look like but these will do the job:

Forename:

=MID(A1,FIND(", ",A1)+2,255)

Surname:

=LEFT(A1,FIND(", ",A1)-1)

Both, far from clunky!

You could use DataText to Columns but it's not automatic.

Biff

Thanks, that is the formula I used more or less, but thought it was a bit
clunky. Since you can split data into columns via the menu, I thought there
would be an equivalent function like SPLIT or TOKENISE or something
not to worry, thanks for the help