Forum Discussion
Remove last name formula in excel
Hello, I have column with some names like below I need formula to remove the last name only from them John Smith john Abraham smith john john smith Abraham I tried many formulas but the...
Let's say you have names in A2 and down.
In B2:
=IFERROR(TEXTJOIN(" ", TRUE, DROP(TEXTSPLIT(A2, " "), , -1)), A2)
Fill down.
HansVogelaar Thanks it works perfectly
