sort only based on number

[amir0914]

Hi guys, I have a lot of text with number in coulmn "A" and I need a way to sort column with only number, as below image:

[/IMG]

can someone help me?

 

[DanteAmor]

If your data starts in A2, put the following formula in B2

=--MID(A2,3,LEN(A2))

Copy down



Sort columns A and B with reference to column B

 

[Gerald Higgins]

I would use a helper column to strip out the numbers, then sort on that.

For example, if ALL of your data involves exactly two (never more, never less) letters, followed by numbers, try

=mid(C1,3,10)

and copy down as far as required.
This assumes none of the codes will contain strings of digits longer than 10 characters - adapt as required.

Then select all your data, both column C and the helper column, but using the helper column as your sort key.