OMG...have I told you lately that I absolutely LOVE you, Bob!!! That was
exactly what i needed!! thanks so much!!!

Liz

"Bob Phillips" wrote:

DataText To Columns with a space delimiter

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wrosie" wrote in message
...
I have a spreadsheet in which the Name column contains both first and last
name. Is there a way to make this into two columns, one for the first name
and one for the last name, for mail merge purposes without retyping all
400+
names?