Help with special sort??

[jaclyde]

Hi,

I would like to sort a column starting with the 2nd number in the data, rather than the 1st. The data is all 4-digit numbers (i.e. 4564,7897,3543) and I've got Excel 2000.

Any ideas? It seems like it should be possible, I just can't figure it out!

Thanks,
jc

[Bryan Hessey]

Hi,

I would like to sort a column starting with the 2nd number in the data, rather than the 1st. The data is all 4-digit numbers (i.e. 4564,7897,3543) and I've got Excel 2000.

Any ideas? It seems like it should be possible, I just can't figure it out!

Thanks,
jc

Hi,

the easy way would be to use a helper column with the formula

=MID(A1,2,LEN(A1))

filled down that column, and sort on that.

The helper column can be deleted after the sort.

hth
---

[jaclyde]

Thanks! That did it.

jc

[Bryan Hessey]

Thanks! That did it.

jc

good to see, and thanks for your response.

---

[realsaggi]

Another Way.......

Mid(A1,2,4)