ExcelBanter - Data sort

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data sort (https://www.excelbanter.com/excel-discussion-misc-queries/139478-data-sort.html)

Data sort

How do I sort data in accending order when the data has text first and then
numbers seperated by a dash such as; boy-1, boy-2, boy-3?

Teethless mama

Data sort

Data Sort Ascending OK

"JK" wrote:

How do I sort data in accending order when the data has text first and then
numbers seperated by a dash such as; boy-1, boy-2, boy-3?

All times are GMT +1. The time now is 02:36 AM.