Need to filter A-Z column starting with a letter and a number

[Waylonjennings]

I am trying to filter the following

T1
T2
T3
T4
T5
T6
T7
T8
T9
T10
T11
T12
T13
T14
..........
When I filter A-Z I get
T1
T10
T11
T12
..........
T19
T2
T20

I can't put a 0 in fount of the single digit because I need that exact number as is.
Anyone have this problem or any suggestions?
Thanks for the help

 

[Rick Rothstein]

You could use a helper column... put this formula in the first cell, copy down and filter (sort?) on that column.

=IF(LEN(A1)=2,REPLACE(A1,2,0,0),A1)

 

[Waylonjennings]

You could use a helper column... put this formula in the first cell, copy down and filter (sort?) on that column.

=IF(LEN(A1)=2,REPLACE(A1,2,0,0),A1)

Worked like a charm. Thanks for the help