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

M

MandiMDA

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.
 
F

Frank Kabel

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
 
D

Debra Dalgleish

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?
 

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

Excel does not accept text format! 0
Merging from an Excel file with graphics 1
Keep First Letters, with exceptions 0
Delete all data after a symbol in a field 0
How to replace text with numbers? (formula) 4
Improving Macro That Keeps First Letter 0
Autonumber field in Excel that behaves the same as Access 0
range definition by cells numbers 3

Top