| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Splitting one column into two
I have a spreadsheet which contains one column of names, (last name,
first name). I would like to split this into two columns so that I will have the last name in one column and the first name in another so that I can use either the first or last name in a mail merge. Is there way to do this? Thanks-- BJ |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Splitting one column into two
Are the names seperated by a space? or by a comma?
Data...text to columns....delimited... and then choose what seprates the names (space, or comma or whatever) this should split them up for you. "Big John" wrote: I have a spreadsheet which contains one column of names, (last name, first name). I would like to split this into two columns so that I will have the last name in one column and the first name in another so that I can use either the first or last name in a mail merge. Is there way to do this? Thanks-- BJ |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Splitting one column into two
Both. As in " Smith, John"
Thanks for the help!! BJ tim m wrote: Are the names seperated by a space? or by a comma? Data...text to columns....delimited... and then choose what seprates the names (space, or comma or whatever) this should split them up for you. "Big John" wrote: I have a spreadsheet which contains one column of names, (last name, first name). I would like to split this into two columns so that I will have the last name in one column and the first name in another so that I can use either the first or last name in a mail merge. Is there way to do this? Thanks-- BJ |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Splitting one column into two
Hi,
For your reference http://office.microsoft.com/en-us/as...498511033.aspx Does it help? Epinn "Big John" wrote in message et... Both. As in " Smith, John" Thanks for the help!! BJ tim m wrote: Are the names seperated by a space? or by a comma? Data...text to columns....delimited... and then choose what seprates the names (space, or comma or whatever) this should split them up for you. "Big John" wrote: I have a spreadsheet which contains one column of names, (last name, first name). I would like to split this into two columns so that I will have the last name in one column and the first name in another so that I can use either the first or last name in a mail merge. Is there way to do this? Thanks-- BJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
