How to sort combined alphabet and numerical value?

[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

 

[Pete_UK]

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

 

[Harshad]

Hi dera Pete,

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

Keep it up.

With regards,
Harshad