if you have only S as first character of some of your data and rest of
numbers are not fixed then in col B (if your data starts from cell A1),
enter the following function in B1
=IF(LEFT(A1,1)="S",MID(A1,2,10),A1) and copy it down, it will extrat
only numbers from your data. Then select col B and copy it, without
deselecting, right click on the selection area, click paste special and
click values then ok. Now select col A and B and sort by col B in
ascending order. delete values from col B. you data is sorted in
ascending order as per numbers.

hope this would help you.

Wrote:
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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=562046