Text parsing

  • Thread starter Thread starter Bellyjeans
  • Start date Start date
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!
 
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
 
Back
Top