MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.