Seperate Name

jgneely72151

Below is a formula I found here in the Community. While the first name worked, the last name didn't. Well, it did but the comma is appearing. I also noticed that if the hyphenated name is lenghty, it only returns the first part of the last name, the dash and first letter.

I also have names that are pretty lenghty that includes preferred names in parenthesis for example:

Neely (Jenn), Jennifer Genelle

Should be Jennifer Neely.

I need just a first and last name yielded. Any help will be appreciated.

Name	First	Last
Name	Doe-Smith, Jasmine Marie	First	Jasmne Marie	Last	Doe-Smith,
Name		First	=RIGHT(NAME@row, LEN(NAME@row) - FIND(" ", NAME@row))	Last	=LEFT(NAME@row, FIND(" ", NAME@row) - 1)

Mark.poole

You only have it looking for the space and not the comma. Try.

=Left(Name@row,Find(", ",Name@row)-2)

How ever due to the nature of how the names are created. The only consistent thing that can be pulled is the first name.

Mark.poole

You only have it looking for the space and not the comma. Try.

=Left(Name@row,Find(", ",Name@row)-2)

How ever due to the nature of how the names are created. The only consistent thing that can be pulled is the first name.

jgneely72151

Thanks for your help and feedback!