Try selecting your column, and use Data--Text to columns.
http://www.officearticles.com/excel/...soft_excel.htm
(About halfway down the page)
************
Anne Troy
www.OfficeArticles.com

"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