I have problem with Structural drawings member numbering. I have beam no. like 01B1, 01B2, 01B3, 01B4, 01B5, 01B6, 01B7, 01B8, 01B9, 01B10, 01B11, 01B19, 01B20, 01B21, 01B22, 01B30, 01B31, 01B32, 01B39,01B40,01B42.
When I am sorting it with A~Z, it's not working properly. it is coming like, 01B1, 01B10, 01B11, 01B19, 01B2, 01B20, 01B21, 01B22, 01B3, 01B30, 01B31, 01B32, 01B39, 01B4, 01B40, 01B42, 01B5, 01B6, 01B7, 01B8, 01B9.
Even after using "=TEXT(A1,00)" formula too. Please help.