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
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
Please sign in to leave a comment.