SORTING 1,1A,2,3,4A

[Tboy]

I thought I knew how this works, but it's not responding like I thought.

The column that I have the data in is formatted at text.

But when I sort, it gives me:
1
2
3
1A
4A

I thought if the entire column is text, then it should sort in dictionary
order. Am I wrong?

 

[Dave Peterson]

It's not enough for the format to be text. The values in the cells have to be
text, too.

So if you entered 1 (as a number), then changed the format to text, you'll have
to reenter the value.

And in newer versions of excel, there's a choice offered to you to sort anything
that looks like a number as a number. Make sure you don't choose that.

 

[YESHWANT]

there is other way also of doing this

seperate these alpha numeric values to two new columns
may be with the help of formulas i. e. left, right, mid etc. as the case
may be
and then sort the data on numeric value first and on alpha value second
or as per your choice.

hope this helps you

learn - n - enjoy