I’m using the Left and Right formulas to parse first and last names from a full name column. The Left formula is working perfectly: =Left(Name,Find(" ",Name)-1) With the name Abby Malvestuto, that returns, correctly, “Abby.” However, when I use the Right formula for the last name, some rows are co…

Parsing First/Last Name Issue

shishir October 5, 2018, 5:41am 6

Here’s a way to handle people with multiple first names:

7 Likes

Playground Doc - A Collection of Tips, Tricks, and Examples

Button to Modify Rows, Split First and Last Name

How to ignore or remove middle name/initial

Topic		Replies	Views
Finding the first word and last word in a string - use case: splitting full name into first and last name	7	1321	May 16, 2022
Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks	15	7616	November 11, 2020
Abbriviate Second Word	8	790	February 6, 2022
Button to Modify Rows, Split First and Last Name	9	1356	December 18, 2019
How to ignore or remove middle name/initial	4	1072	July 22, 2019