Hi all,
I have absolutely NO experience with excel, and I am trying to sort lot numbers which are followed by a letter; eg:

1B
5B
19B
45B
190B
247B
560B

However I can only sort so it renders my results

1B
19B
190B
247B
45B
5B
560B

Every formula I've looked at is much too complex for what I'm trying to do, and as I have no experience with excel, I do not understand how to adapt the formula to my needs.

Help would be greatly appreciated, but please in lamen's terms. :)