sorting combined alpha character with numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I sort alpha and numbers. (i.e. 6-A, 1-A, 2-A, 1-B,11-A
I want it to sort 1-A, 1-B, 2-A,6-A, 11-A
Thanks
 
Hi
you may use two helper columns for this and sorting with these helper
columns. e.g. use the following two formulas
=--TRIM(LEFT(A1,FIND("-",A1)-1))
and
=TRIM(MID(A1,FIND("-",A1)+1,255))
and copy both formulas for all rows.
 
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

Alpha sorting (with a twist...?) 3
Removing Trailing Alpha? 8
Wildcards in If statements 4
Sort 6
Sorting number combinations 9
Lookup 5
Numbers from first column 5
Sorting a list of numbers 4

Back
Top