Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Separating Names in a Column to Two Columns
I need to export a great deal of data, where the last and first names need to
exist in two separate columns, i.e., Doe, Jane to Doe Jane Is there any way to accomplish without retyping? Thanks, D |
#2
|
|||
|
|||
Look at DataText to columns in the main menu
-- Kind Regards, Niek Otten Microsoft MVP - Excel "donniebrook" wrote in message ... I need to export a great deal of data, where the last and first names need to exist in two separate columns, i.e., Doe, Jane to Doe Jane Is there any way to accomplish without retyping? Thanks, D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula - sum "x" column L only when same row contains "y" columns | Excel Worksheet Functions | |||
excel case changes on a column of first names | Excel Discussion (Misc queries) | |||
Making a One Column Directory from Two Columns | Excel Discussion (Misc queries) | |||
merge data from multiple columns to single column | Excel Worksheet Functions | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |