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

[Guest]

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

 

[Gilles Desjardins]

Type them in with an apostrophe '11111 '444454 In other words use them as
text
HTh

Gilles
"Stuck in Africa help me please" <Stuck in Africa help me
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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

 

[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
(e-mail address removed)> wrote in message
news:[email protected]...