Organizing Data in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

1. Simple Data Sorting:

2. Sort Names in Alphabetical Order.

This article provides a detailed guide on how to sort a database in Excel.

Sorting data is an essential task when working in Excel.

1. Simple Data Sorting:

Step 1: Select the data range to be sorted -> Data -> Sort:

Step 2: The Sort dialog appears. Choose the data field to sort by in the Sort by -> select the sorting type in the Order section. For example, here we are sorting revenue from low to high:

After clicking OK, you'll get the result:

2. Sort Names in Alphabetical Order.

Step 1: Insert three new columns for last name, middle name, and first name as shown in the image:

Step 2: Copy the entire Name column to the Name -> press Ctrl + H -> the dialog appears in the section:

- Find What: Enter an asterisk and space.

- Leave the Replace with field blank.

- Finally, click Replace All:

Step 3: After clicking Replace All, you'll get the result:

Step 4: In cell C9 in the Last Name column, enter the formula as shown in the image:

Step 5: Press Enter and copy the formula for the remaining values in the column to achieve the result:

Step 6: Copy the entire Last Name column and paste using Paste Value -> Copy the Last Name column again -> paste it to the Middle Name column -> press Ctrl + H -> the dialog appears in the section:

- Find what: Enter an asterisk and a space.

- Replace with: Leave it blank.

- Finally, click Replace All:

Step 7: Copy and Paste the Middle Name column using Paste Value. In cell C9 of the Last Name column, enter the formula as shown in the image:

Step 8: After pressing Enter, copy the formula for the remaining values in the column to achieve the result:

Step 9: Perform Copy and Paste for the Last Name column using Paste Value to get the result:

Step 10: Select the entire data table in Data -> Sort -> the dialog appears, enter the values as shown in the image (to add a sorting level, click Add Level):

Step 11: After clicking OK, the entire data in the table is sorted:

- In case you want to merge the three columns Last Name, Middle Name, First Name into the Last Name and First Name column, concatenate the three strings by adding a space:

- Press Enter -> copy the formula for the remaining values in the column -> perform Copy for the Last Name and First Name column and Paste using Paste Value -> delete the three columns Last Name, Middle Name, First Name to get the result:

Here is a detailed guide on how to sort a database in Excel 2013.

Wishing you all success!

Frequently Asked Questions

What are the initial steps for sorting a database in Excel?

To sort a database in Excel, first select the data range you want to sort. Then navigate to the Data tab and click on Sort. In the Sort dialog, choose the data field to sort by and specify the sorting order, such as sorting revenue from low to high.

How can I sort names in alphabetical order within Excel?

To sort names alphabetically, insert new columns for last name, middle name, and first name. Then, copy the Name column, use the Replace feature to separate names, and apply formulas to extract last and middle names before finally sorting the entire table alphabetically.

What method do I use to concatenate names in Excel?

To concatenate names in Excel, use a formula to combine last, middle, and first names with a space in between. After entering the formula, copy it down for all rows, then use Paste Values to finalize the combined names and delete the original separate columns.

Can I add multiple sorting levels in Excel when sorting data?

Yes, you can add multiple sorting levels in Excel. After selecting your data and accessing the Sort dialog, you can click 'Add Level' to specify additional sorting criteria, such as sorting by last name first and then by first name.

What steps should I follow to perform a simple data sort in Excel?

To perform a simple data sort in Excel, select the range of data, go to the Data tab, and click Sort. Choose the sorting field and order in the dialog box that appears, and click OK to sort your data according to your specifications.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]