![]() This means that if I add more names to my list, I will have to do the same process again to get the last names. While the method that’s shown above (using Find and Replace) is what I prefer to get all the last names and sort based on it, one limitation of it is that the resulting data in static. Extract and Alphabetize by Last Name Using Formula Now, if you need the original data back, you get it by sorting based on the numbers. To do this, in an adjacent column (left or right), have serial numbers before the sorting. Pro Tip: At any point in time, if you think you may need the original data back, you need to have a way to un-sort this dataset. Once done, you can delete the column that has the last name. The above steps would sort the entire selected dataset based on the last name. In the ‘Sort by’ option, select the name of the column that just has the last name.In the Sort dialog box, make sure ‘My data has headers’ is selected.You can also include other columns that you want to sort along with the names Select the entire dataset with headers (including the full names and the extracted last names).Once you have the last names in the adjacent column, you can easily sort the dataset (including the full names) alphabetically based on the last name. This works well even when you have middle names or prefixes (such as Mr. 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. Archives
December 2022
Categories |