Formula
Posted by Tim on June 29, 2001 8:07 AM
How do you separate a long column of "last_name, first_name" to two separate columns of "First name" and "last name" respectively? Any help on the formula would be greatly appreciated.
Thanks in advance.
Posted by IML on June 29, 2001 8:25 AM
Assuming the name in column A, for first name
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)
last name
=LEFT(A1,FIND(",",A1)-1)
and copy down.
A better option may be highlighting column A and going to Data text to columns.
Hit next, and set comma as the delimter and finally finish.
Good luck and I'm lobsterless in landlocked colorado.
