how do i sort by numerical prefix ? 1423 would come before 850

  • Thread starter Stuck in Africa help me please
  • Start date
S

Stuck in Africa help me please

Help me I need to sort a table by numerical Prefix , For example if I hade
the following 4 numbers 85,444454, 11111, 99 they should sort as
11111,444454,85,99

I have a 2002 hp excel program

Thanks
 
K

Karthik

I just tried and got the result you wanted. Put the numbers to be sorted in
column A and in column B, write the formula =left(A1,1) and copy it to the
entire range.

Then sort by column B first and then by column A. Once you say OK, you will
get a warning. Select the radio button against the option

Sort numbers and numbers stored as text separately.

And voila! You should get what you want. Hope it works

Karthik
 
B

Bob Phillips

You could also add a helper column with a formula of

=A1&REPT("0",10-LEN(A1))

copy down, and sort by the helper column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Stuck in Africa help me please" <Stuck in Africa help me
[email protected]> wrote in message
news:[email protected]...
 
Top