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
(In this scenario let's assume George Bush has no middle initial)
and my desired results are:
What formula can I use?
Help Article Resources
Check out the Formula Handbook template!