A sorting conundrum

[sleepdoc]

I have 6 pieces of data in a column

109
109a
109b
110
110a
110b

how do i sort this column of data so it looks like what i am showing here?

Help much appreciated.

 

[Ron Coderre]

You have a combination of numbers and text. Consequently, the numbers will sort above the text.

Try this:
• Select your range of values
• Data.Text-to-Columns...next...next...Check: Text...Finish
• Sort the data.

Does that help?

 

[Rick Rothstein]

I have 6 pieces of data in a column

109
109a
109b
110
110a
110b

how do i sort this column of data so it looks like what i am showing here?

The following assumes this is your only data... if that is not the case, you should be able to modify this to include your other data.

Put this formula in the column next to your data...

=IF(ISNUMBER(-RIGHT(A1)),A1&"@",A1)

Then select your data column and column next to it and sort by the column next to it, then clear the column next to your data.