Sorting Problem in Pivot Table Column that contains both Number and Alphabets

Greetings !!

Sorting Problem in Pivot Table Column that contains both Number and Alphabets

\1

In this file the survey number field contains both number and alphabets. When insert pivot table the ascending order of that column is not really ascending .. Please Help..

\1

Thanks

Excel sorts based on the first character of the string.
Which are your criteria for sorting ? The shortest string before the hyphen first ?

Sir,
The sorting criteria is like in J column

\1

like

1-1
1-1A
1-1B
1-2A

like

but as you see in pivot table column

53--
54-4
54-54
.
.
.


are in lower... it should come in first

Thanks in Advance