I have a list that contains a field for road number. It sorts like the left
column, but I want it to look like the right column:

Road Number Road Number
2 1A
11 11
21 100
100 101
101 1000
200 10000
201 10000A
1000 2
10000 2A
10000A 2B
1A 200
2A 201
2B etc

I have formatted the data to be text, but that doesn't deliver the sort
order that I want. I am hoping that I can use formulas to do this, as I am
not familiar with VBA. Thanks in advance for your help.
--
Thanks, Allison