How to sort combined alphabet and numerical value?

  • Thread starter Thread starter Harshad
  • Start date Start date
H

Harshad

I have values like in column A: (1-Mahesh), (Denish), (Jignesh), (2-Ramesh),
(1,1-Luicey), (1,1,1-Burman), (2,3,3-Barton).....etc.

I want it such a way that in apears like Alphabet, not number. I also want
to include numerical value. Sort order like, 2,2,3-Barton; 1,1,1-Burman;
Denish; Jignesh, 1,1-Lucey; 1-Mahesh; 2-Ramesh.

Hope someone have solution.

Harshad
 
Put this formula in B1:

=IF(ISNUMBER(FIND("-",A1)),RIGHT(A1,LEN(A1)-FIND("-",A1)),A1)

and copy down as required.

Then apply the sort to both columns, using column B as the sort field.

Hope this helps.

Pete
 
Hi dera Pete,

Thank you very much.
Your answer has saved my so many working hrs.

Keep it up.

With regards,
Harshad
 
Back
Top