Separating a column containing a first and last name...

[wrosie]

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?

[Bob Phillips]

Data>Text To Columns with a space delimiter

--
HTH

Bob Phillips

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

"wrosie" <wrosie@discussions.microsoft.com> wrote in message
news:36DB3EEC-A9E9-4334-A260-554BEC5CCBE8@microsoft.com...
> 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?