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
Parsing First/Last Name Issue	10	4094	November 15, 2022
Button to Modify Rows, Split First and Last Name	9	1397	December 18, 2019
A filter formula is driving me nuts	4	1063	March 5, 2020
Remove some elements from cell	5	788	May 17, 2022
Capitalize the first letters of first and last name (Title Case / Camel Case / Capital Case / Proper Case) Tips and Hacks	18	7853	November 11, 2025

How to ignore or remove middle name/initial

Related topics