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

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