Sorting Letters and Numbers

[b19upj]

Hi,

I need to sort a table to be in order of the numbers and letters from column A.
They are not in order at the moment. I would like them to look like this:
1
1a
1b
1c
1d
1e
1f...
2
2a
2b
2c
2d
2e... etc

Pressing 'Sort A-Z' does not give me this.

Any suggestions?

TIA

 

[Mike LH]

Put this formula in a helper column


=LOOKUP(1E300,--LEFT(A1,ROW(INDIRECT("1:"&LEN(A1)))))

Select your data and the helper column and sort on the helper column.

 

[KenWit]

You can do this by features on the ribbon.
First separate the numbers from the letters, using the text to columns on the data tab. (use "fixed with" in the dialogue box and used the slide ruler)
Then select both columns and use the custom sort on the home tab. Use the add level button to select a second column to sort by.
Then when that's done use concatenate to get your original letter/number format back.

 

[modocc]

I have the same problem. I a quite new to this and have no clue what a helper column is. Will this formula work on any column or do I have to change numbers?

 

[KenWit]

A helper column is just a blank column to the left or right of the one your data is in. Insert one if needed. That's where you put your formula and get your altered data.
Yep, the numbers have to be changed depending on where your data is.