Forum Discussion
Sorting a Number with dash
Let's say the data start in A1.
Make sure that columns B and C are empty (insert columns if necessary).
Select the data.
On the Data tab of the ribbon, in the Data Tools Group, click Text to Columns.
Select Delimited, then click Next >.
Tick the check box for Other, and enter a dash (hyphen) in the box next to it.
Click Next >.
Enter or select B1 in the Destination box (to avoid overwriting the data.
Click Finish.
Select cell A1, or the entire range.
In the Sort & Filter group of the Data tab of the ribbon, click Sort (not the Sort A to Z or Sort Z to A buttons).
Select Column B in the Sort By dropdown, then add a new level and select Column C.
Click Sort.
If you wish, you can now clear columns B and C.
Let's say the data start in A1.
Make sure that columns B and C are empty (insert columns if necessary).
Select the data.
On the Data tab of the ribbon, in the Data Tools Group, click Text to Columns.
Select Delimited, then click Next >.
Tick the check box for Other, and enter a dash (hyphen) in the box next to it.
Click Next >.
Enter or select B1 in the Destination box (to avoid overwriting the data.
Click Finish.
Select cell A1, or the entire range.
In the Sort & Filter group of the Data tab of the ribbon, click Sort (not the Sort A to Z or Sort Z to A buttons).
Select Column B in the Sort By dropdown, then add a new level and select Column C.
Click Sort.
If you wish, you can now clear columns B and C.
Thank you so much.