MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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
last name
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.