ascending order

excuse me if this is not the right place to put my question over here, am just new!

however, the question is : you may have some weird problem such as the one am facing. the items are B7,B8C,B9B,B10A. i need to enter them as is. but when doing the ascending ordering the list appears up as the photo attached. logically B7 should be the fist B10A should be the last item.

be aware that i need to enter the item as it shown above, not adding ' 0 ' after ' B ' letter.

Regards,

Good morning cbian

...and welcome to the forum!!

This is due to the way Excel sorts - it (quite rightly) recognises what is in your sheet as a text string, not a number. You can force it to sort numerically by using a helper column, and extracting the number from your string.

Put the code below into an empty module, and if your text string is in column A, starting at A1, then put this formula in (say) column B :
=GetNumber(A8)
and copy it down. Then sort on column B.

Function GetNumber(Sce As Range) As Double
NewNo = ""
For n = 1 To Len(Sce.Value)
c = Mid(Sce.Value, n, 1)
If c Like "#" Then
NewNo = NewNo & c
Else
End If
Next n
GetNumber = --NewNo
End Function

HTH

DominicB