Hi, Could use your input. Working with 2 table of customer data to match names. One has middle name info. How do I edit the formula in Table 1-cars owned to match and return value of cars in table 2. Here’s the sample coda doc. *Alternative solution how do I write a formula in table 1 eliminati…

Hi Mina, Hopefully this can help :blush: Also note that the First Name and Last Name formulas in this doc are not the same as the one posted by @Dalmo_Mendonca because that solution included all the First Names if there were multiple, which may not be what you wanted, so I modified it in the linke…

How to ignore or remove middle name/initial

Dalmo_Mendonca July 16, 2019, 7:46pm 2

Not the same but closely related so it might help:

1 Like

Topic		Replies	Views
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
Remove some elements from cell	5	724	May 17, 2022
Format for names - and how to add new names	3	1343	May 27, 2020
Button to Modify Rows, Split First and Last Name	9	1344	December 18, 2019
Parsing First/Last Name Issue	10	3982	November 15, 2022

How to ignore or remove middle name/initial

Related topics