Sort a text column that contains alphanumeric

  • Thread starter Thread starter Maureen
  • Start date Start date
M

Maureen

I want to sort the following which is all formatted as text:
REA240
REA250
CAP010
TIP031
CUP001

When I hit sort, it converts everything to numbers, although it is still
formatted as text, so I end up with the column looking like:
221001
221041
221051

How do I prevent it from chaning my fields?
 
You sure that those values didn't just get sorted to where you were viewing?

Did you have any hidden rows where they might have popped up from?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting alphanumeric 4
Sorting Numbers that have Text 2
vlookup with numeric and alphanumeric identifiers in lookup_value 1
sorting numbers and numbers that contain text in excel 2
convert text to date 2
Text string sort limit 2
Removing Text from Alphanumeric values 6
sorting alphanumeric text 4

Back
Top