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	1282	May 16, 2022
Formula doesn't populate table?	2	410	May 3, 2021
Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks	15	7537	November 11, 2020
Abbriviate Second Word	8	780	February 6, 2022
Formula Help when Slicing Paragraphs of Text	4	419	September 19, 2023