Text parsing

B

Bellyjeans

Hi everybody,

I have to parse a column of data into two fields - last name and first
name. The data was originally entered in as:

LastName, FirstName

I need it separated into:

LastName
FirstName

I've figured out how to extract the last name using =LEFT(A2, FIND(",
",A2)-1). I am, however, a bit stumped as to how to extract the
FirstName field.

Would anybody happen to know how to go about doing this?

Thanks!
 
R

Ron Rosenfeld

Hi everybody,

I have to parse a column of data into two fields - last name and first
name. The data was originally entered in as:

LastName, FirstName

I need it separated into:

LastName
FirstName

I've figured out how to extract the last name using =LEFT(A2, FIND(",
",A2)-1). I am, however, a bit stumped as to how to extract the
FirstName field.

Would anybody happen to know how to go about doing this?

Thanks!
Click to expand...


=TRIM(MID(A1,FIND(",",A1)+1,99))

--ron
 

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

Getting a message box program to run (Page 43 of 'BeginningProgramming with VBA' by Duane Birnham) 11
Parsing inconsistent data 6
How to compare and extract data in two columns 1
Split Names 2
Text to columns question 4
Parsing Names 6
How do I get IIf(IsNull.... to work?? 3
Remove extra space between first and last names in merge 1

Top