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

"Lee Harris" wrote in message
...
I've a column of text, generally in the form

Surname, Forename


I want to split into two columns automatically with Forename and Surname
separately. I've been able to do it with MID and FIND, but it's quite
clunky and wondered if there was a quicker, easier or more elegant way
just to tokenise a string based on a defined separator (in this case the
character , followed by a space)

tks in advance