Remove Middle Initial from the End of a Name


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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!