separating a list

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

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
 
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.
 
Back
Top