Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
separating a list
I have a single column (1800 rows long) of names in the
format Last, First Middle I'd like to sepatate this into two separate columns of Last then First Middle - sort of like a reverse concatentate. Any ideas would be helpful. Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
separating a list
Select the column and do
Data=Text to Columns select delimited and choose comma as the delimiter in the second dialog. You will need a blank column to the right of the selected column to receive the First and Middle names, the last name will stay in the selected column and the comma will be removed. Test this on a copy of your data. -- Regards, Tom Ogilvy "Brian" wrote in message ... I have a single column (1800 rows long) of names in the format Last, First Middle I'd like to sepatate this into two separate columns of Last then First Middle - sort of like a reverse concatentate. Any ideas would be helpful. Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separating a list | Excel Discussion (Misc queries) | |||
Separating a List onto multiple worksheets in the same workbook based off 1 criteria | Excel Worksheet Functions | |||
Separating Rows | Excel Discussion (Misc queries) | |||
Separating a column containing a first and last name... | Excel Discussion (Misc queries) | |||
separating text | Excel Worksheet Functions |