How to Remove Initials


How to remove the initials from a string that contains a name.


1. Source data from column A.

John A. Smith
John A Smith
Bob A.J. Johnson
Tom K. Brown

2. In column B, create a List with a space as a separator via the formula TOKENIZELIST(#A;" ").

3. In column C, add the 1st (Name) and the 3rd (Surname) element of the list and put them together into a string via T(LISTELEMENT(#B;0)+" "+LISTELEMENT(#B;2)). Note that the count for the LISTELEMENT function starts from 0, therefore the formula has 0 and 2, instead of 1 and 3.
4. Final result in column C.

John Smith
John Smith
Bob Johnson
Tom Brown