Sorting a Number with dash

B_KRANTHI_KUMAR

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.