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
Doe-Smith, Jasmine Marie	Jasmne Marie	Doe-Smith,
	=RIGHT(NAME@row, LEN(NAME@row) - FIND(" ", NAME@row))	=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.