![]() ![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |