comma delimited names in columns

R

robbie

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to change a column of names from (Last, First) into two columns of First then Last
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I want to change a column of names from (Last, First) into two columns of
First then Last
Click to expand...

One way:

A1: Last, First

B1: =TRIM(MID(A1, FIND(",", A1) + 1, 255))

C1: =TRIM(LEFT(A1, FIND(",", A1) - 1))

Copy B1:C1 down as far as needed.

You can then get rid of the formulae by selecting columns B:C, Copy,
then Edit/Paste Special, selecting the Values radio button. Delete
column A to finish.
 
Top