Hi,

try to use an auxiliar column with =mid(a2,1,255) copy it down and order by
column B.

hth
regards from Brazil
Marcelo

" escreveu:

I have the following data:

S12345
S12346
12347
12348

I would like to sort it in ascending numerical order, omitting the
leading 'S'. Is there anyway to do this?

Many Thanks,

Jason R. Kaiser Sr.