If necessary, you can delete the new extracted last name column. So far the full name column has been sorted by the extracted last names. Keep selecting the new column, and click Data > Sort A to Z or Sort Z to A, and then in the Sort warning dialog box please check the Expand the selection option, and click the Sort button. Still select the new column, and in the Find and Replace dialog box, enter the in the Find what: box, enter nothing in the Replace with: box, and then click Replace All button.ĥ.
See screenshot:Īnd then a dialog box will pop up and show you how many replacements have been made, just click the OK button to close it.Ĥ. In the opening Find and Replace dialog box, please type a space into the Find What: box, type the into the Replace with: box, and then click the Replace All button. Note: You can also open this dialog box by clicking Home > Find & Select > Replace.ģ. Keep selecting the pasted column, and press the Ctrl + H keys simultaneously to open the Find and Replace dialog box. Copy the full name column, and paste it beside the full name column, says Column B.Ģ. This method will introduce the Find and Replace feature to extract the last names from all full names, and then you can sort full names by the last name easily.