The above steps would keep the last name and remove everything before it. This would instantly replace all the first name and you will be left with last names only. In the Find what field, enter * (asterisk symbol followed by a space character).This will open the Find and Replace dialog box. Hold the Control key and then press the H key.Select all the copied names (don’t select the header).In this example, I will name is ‘Last Name’ Copy it in the adjacent column (if the adjacent column is not empty, insert a new column and then copy these names).Select the dataset including the header (in this example, it would be A1:A10).Suppose you have a dataset as shown below and you want to sort this data alphabetically using the last name.īelow are the steps to sort by the last name: You can do that by replacing everything before the last name with a blank so that you only have the last name left. The first step to sorting by the last name is to get the last name in a separate column. Extract and Alphabetize by Last Name Using FormulaĮxtract and Sort by Last Name Using Find and Replace.Extract and Sort by Last Name Using Find and Replace.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |