Remove Middle Initial from the End of a Name

Automations 1

Hi,

I'm looking for a formula that will remove the middle initial from the end of a name.

For example, I currently have:

Biden, Joe R

Trump, Donald J

Obama, Barack H

Bush, George

(In this scenario let's assume George Bush has no middle initial)

and my desired results are:

Biden, Joe

Trump, Donald

Obama, Barack

Bush, George

What formula can I use?

Paul Newcome

Try something like this...

=IFERROR(LEFT([Name Column]@row, FIND(" ", [Name Column]@row, FIND(" ", [Name Column]@row) + 1) - 1), [Name Column]@row)

Paul Newcome

Try something like this...

=IFERROR(LEFT([Name Column]@row, FIND(" ", [Name Column]@row, FIND(" ", [Name Column]@row) + 1) - 1), [Name Column]@row)

Automations 1

Thank you @Paul Newcome that worked!

Paul Newcome

Happy to help. 👍️