comma delimited names in columns

[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

 

[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

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.