Sorting row with a alphanumeric value.

I want to sort out my row by ascending/descending order. I know there is a function for that, but when i have Alpha-numeric value in my cell (like B1, B2, B3) i can't sort it. When i try to sort my row B11 comes after B1, but i want B2 to come after B1. Can anyone solve my problem?

Thank you.

You would have to introduce a helper column that extracts the number and then sort by that column...

if it is indeed as you say, i.e. b1, b11, b45... then a formula like =--Mid(A2,2,255) would extract the number from A2...

You could create a personalized list using those values.

Go to "tools" "Options" "Personalized list" and import those values sorted as you want.

You can then use the sort option from your "data" tab and use the "custom sort" to "sort by" the list you just created.