How to sort combined alphabet and numerical value?
 

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

How to sort combined alphabet and numerical value?
 

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

On Sep 24, 6:05*am, Harshad wrote:
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

How to sort combined alphabet and numerical value?
 

Hi dera Pete,

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

Keep it up.

With regards,
Harshad

"Pete_UK" wrote:

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

On Sep 24, 6:05 am, Harshad wrote:
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