Sorting Columns in Ascending Order

**COLIN_303** · 04-17-2013, 05:51 AM

Hi All

Iam have trouble sorting one of my Columns (Column C) into Ascending Order, the column contains Numbers & Text eg 13A

the way it is currently sorted is:

13A
1B
2A

Where as I want it to be Sorted by Number then by Text eg:

1B
2A
13A

Attached is a copy of the workbook and the macro that i have been using, any help will be much appreciated

Kind Regards
Colin

Please Login or Register  to view this content.

**martindwilson** · 04-17-2013, 06:22 AM

id do it with a formula in g2 assuming ther are only single alpas after numbers ie 32a not 32aa
=TEXT(LEFT(C2,LEN(C2)-1),"000")&RIGHT(C2) fil down then sort by column G