You will need to separate the numeric part into a "helper" column and then
sort.

If data always has 5 digits as per your sample then

=Right(A1,5) will extract the numeric part. Copy down and sort on this column.

HTH

" 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.