Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reorgainizing Data
In my spreadsheet I have a column that list many names. The format is:
first name <space last name. I want to reformat the data into a new cell, but this time it needs to be: last name, first name. Is there a easy way to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reorgainizing Data
One way....
Highlight the cells in the column and go to DataText to columns and follow the procedures. This will put the first name in one column and the last name in the next column. It's always good to keep such data in separate columns so that it aids searches, and other data manipulation, but if you must have the first and last in one column, then do the following as well. If the first name data is now in column B and the last name in column C use this formula to combine as Last space First. =C1 &" "&B1 and copy this down the required rows. Rob "mjcam349" wrote in message ... In my spreadsheet I have a column that list many names. The format is: first name <space last name. I want to reformat the data into a new cell, but this time it needs to be: last name, first name. Is there a easy way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |