Text parsing

[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!

 

[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!

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

--ron

 

[Bellyjeans]

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

--ron- Hide quoted text -

- Show quoted text -

Genius! Thanks, Ron!

 

[Ron Rosenfeld]

Genius! Thanks, Ron!

You're welcome. Glad to help.
--ron