Sorting cells that have numbers and then letters by the numbers?

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

Guest

I have cells that read eg: 15cd, 06mx, 24ab and want to sort these cells by the numbers not the figures so that my end result is 06mx, 15cd adn 24ab - can anyone tell me how to do this in Excell. Everytime I try it gets sorted by the letters not the numbers.
 
Hi
I would add a helper column with the following formula
=LEFT(A1,2)
(assumption: all your entries start the two digits)
and sort by this helper column

Frank
 
The examples that you listed should sort by number, if you select the
cells and click the A-Z button, or choose Data>Sort.

The cells will sort alphabetically, and as long as you have
placeholders, as in 06, the numbers will sort correctly.

What result are you getting?
 
Back
Top