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

Jean_Pierre_Traets August 31, 2019, 6:58am 9

I would like to refer you to this post, with credits to @Asaf_Dafna

Topic		Replies	Views
Finding the first word and last word in a string - use case: splitting full name into first and last name	7	911	May 16, 2022
Formula doesn't populate table?	2	387	May 3, 2021
Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks	15	6115	November 11, 2020
Abbriviate Second Word	8	683	February 6, 2022
Formula Help when Slicing Paragraphs of Text	4	297	September 19, 2023