ExcelBanter - Sorting a1,a2,a10,a11

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

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

- - Sorting a1,a2,a10,a11 (https://www.excelbanter.com/excel-discussion-misc-queries/17231-sorting-a1-a2-a10-a11.html)

Arturo

Sorting a1,a2,a10,a11

D'OH!
What can be done to have this sort as above as opposed to a1,a10,a11a2.

Sincerely,
Arturo

Peo Sjoblom

Only by using a help column that will extract the numbers and sort by that
help column ascending

--

Regards,

Peo Sjoblom

"Arturo" wrote in message
...
D'OH!
What can be done to have this sort as above as opposed to a1,a10,a11a2.

Sincerely,
Arturo

All times are GMT +1. The time now is 12:26 AM.