Quote Originally Posted by 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
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
---