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	1385	May 16, 2022
Button to Modify Rows, Split First and Last Name	9	1384	December 18, 2019
How to ignore or remove middle name/initial	4	1095	July 22, 2019
Abbriviate Second Word	8	811	February 6, 2022
Formula Help - Coda equivalent to ARRAYFORMULA(JOIN("",LEFT	1	660	October 31, 2018