Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Arrangement
I have text in a cell that is in the format:
LastName FirstName MiddleName (ex. Willson James Nichols). Is there a way to switch the text to: FirstName MiddleName LastName (ex. James Nichols Willson)? Thanks. -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Arrangement
1 way.
select the column of names and then click data- text to columns. It's pretty intuative what you go next and you will end up with the names in 3 columns. You can then concatenate then back into 1 column in the order you want using =concatenate(A2,A1,A3) and then delete the 3 columns you created. Mike "Port Man" wrote: I have text in a cell that is in the format: LastName FirstName MiddleName (ex. Willson James Nichols). Is there a way to switch the text to: FirstName MiddleName LastName (ex. James Nichols Willson)? Thanks. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrangement problems. | Excel Worksheet Functions | |||
Arrangement | Excel Discussion (Misc queries) | |||
Data Arrangement | Excel Discussion (Misc queries) | |||
Re-arrangement | Excel Discussion (Misc queries) | |||
Worksheet re-arrangement | Excel Worksheet Functions |