I know this issue has been addressed before but never having been formally trained in Excel, I am ignorant enough to not really understand how to make the answers I found work for me.

I work with architectural drawings on a daily basis and I need to sort room numbers which include text.
Example: 101, 102, 102A, 102B, 102C, 103, 104, 105, 105A, 105B, 106...etc. When I try to sort them the text with letters always end up at the end of the list and I have to cut and paste to put them in order. Can someone give me an easy step-by-step way to resolve this?

Thank you.