Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a column containing a first and last name...
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a column containing a first and last name...
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating a column containing a first and last name...
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|