DataText To Columns with a space delimiter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"David Bateman" wrote in message
...
I have the first and last names in one cell and would like to extract them
into a format that I can sort such as this "lastname, firstname". Is there
a
way to do this?