Excel not sorting numbers correctly

Hello Hans

I have a similar issue, but do not want to use a formulae.  To sort a simple column of alphanumeric items, e.g. T1 T2 T3 .... T30, it sorts all the 1's first, then all the 2's as per above i.e.

T1

T10

T11

.

.

T2

T20

T21

.

.

T30

I would really like the result to be:

T1

T2

T3

.

.

T10

T11

T12

.

.

T20

T21

T22

.

.

T30

My data typically has other columns of co-ordinates, but I like to sort all the data using the first column order.

Is there any standard function that can do this?

I normally pad with zeros after the "T", but it is tedious, e.g.

T01

T02

T03

.

.

T10

Any help will be appreciated.

Regards