Separating a name into first name and last name columns

G

Guest

I have a series of full names in single cells that are formatted the
following way:
<Last Name>,<Space><First Name> - thus it looks like the following:
ADAMS, ROSEMARY

I would like to separate this into two columns and eliminate the comma. I
appreciate any help. I am working in Microsoft Excel 2000 and need answers
in Excel, not in Visual Basic.

Thank you,
THEFALLGUY
 
G

Guest

Or you could use these formulas (assuming the name is in cell A1):

B1 =LEFT(A1,FIND(",",A1,1)-1)
C1 =RIGHT(A1,LEN(A1)-FIND(",",A1,1)-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating first and last names 10
modifying name format within a cell 2
splitting Last Name, First Name 4
Separating a column containing a first and last name... 1
Search two columns in list for first and last name and return Id 4
Need Text to Columns Help! First Name MI Last Name 5
How do I separate first and last names into two columns? 2
Separating Last Name, First Name into Two Fields 4

Top