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…

Okay, I found the problem. The Right formula, unfortunately, just isn’t going to work here. Anyone have any ideas on the best way to get the first and last name here?

One approach may be using the Split ( https://coda.io/formulas#Split ) formula. I setup my sample table like this: [image] In the Split column, I used the following formula: [image] This formula looks for a particular character (in this case a space, which is what is between the quotation marks)…

This worked! I think there needs to be something a little cleaner than this, but I appreciate your help.

Dear @Joseph_Sorensen and @Joseph_B I assume that the below will be of your interest; [image] [image] Amicable, Jean Pierre

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

I love the use of negative numbers in Slice() That’s a cool trick and it never hit me to give that a try. I’m on the lookout for things that need counted backwards now, haha!

What about dealing with the case of the names not all being in Title Case, how can we convert the first letter of each name to upper()? I’m thinking I could do it if I chained like 10 formulas but maybe there’s a more simple way to capitalize / capital case?

Dear @Johg_Ananda I would like to refer you to this post, with credits to @Asaf_Dafna [image] Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks I’ve made a more generalized version

@Jean_Pierre_Traets thanks! that’s actually a post I wrote after finding nothing on the board (this thread was part of my search). Thanks for helping!

I use this formula in the column where I want the First Name to appear, pulling from the column with the Full Name First(Split(thisRow.[Full Name]," ")) input = John Doe —> output = John

Parsing First/Last Name Issue

Jean_Pierre_Traets August 31, 2019, 6:58am 9

Dear @Johg_Ananda

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	6	1489	May 16, 2022
Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks	18	8104	November 11, 2025
Abbriviate Second Word	7	891	November 8, 2021
Button to Modify Rows, Split First and Last Name	9	1461	December 18, 2019
How to ignore or remove middle name/initial	4	1135	July 22, 2019

Parsing First/Last Name Issue

Related topics