How To Sort Column In Excel 2011 For Mac By Year When There Are Months Included In The Data

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. Please do as follows: 1. Copy the full name column, and paste it beside the full name column, says Column B. Keep selecting the pasted column, and press the Ctrl + H keys simultaneously to open the Find and Replace dialog box. Note: You can also open this dialog box by clicking Home > Find & Select > Replace.

Sep 13, 2013  In this video I show how to sort a column while preserving all other columns in a spreadsheet in Excel for Mac. In the first data cell of the new column, type =RAND() and then press Ctrl + Enter. If there are multiple rows of headings, include only the last row of headings. Or open the Sort drop-down list and select Custom Sort (under Excel for Mac 2011). Heading from the dropdown (for example the Growth (last month=100%). Quickbooks for mac printing grid on checks.

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. See screenshot: And then a dialog box will pop up and show you how many replacements have been made, just click the OK button to close it. 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. And then a dialog box will pop up and show you how many replacements have been made, just click the OK button to close it.

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. See screenshot: So far the full name column has been sorted by the extracted last names.

If necessary, you can delete the new extracted last name column. Sort by last name with extracting the last name firstly. Select the full name column without column header, and click Kutools > Text > Split Names. And then in the opening Split Names dialog box, please check the Last name option only, and click the Ok button. See screenshot: 2.

In the second Split Names dialog box, please specified the first cell of destination column beside original full name column, and click the OK button. And then all last names are extracted from full names and placed beside original full name column. See screenshot: 3.

Select the new last name 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. See screenshot: And now the full name column is sorted by the last names. If necessary, please delete the new created last name column as you need. Sort by last name with reversing the first and last names.