At one time I thought I was able to do this by simply formatting the values correctly, but I am having no luck.

Is it possible to sort the following data numerically in a column...

100, 200, 300, 100A, 200A, & 300A



... with the following result.

100
100A
200
200A
300
300A


At present, when I sort this data it sorts as such...

100
200
300
100A
200A
300A

I am aware that there are ways to sort this by using formulas and "helper columns", but for my purpose that would just be ridiculously cumbersome.

Any help would be greatly appreciated!

I know Excel asks me, when it sees text values that have only numeric characters, whether I should "sort anything that looks like a number, as a number". But that's not what we're talking about here; "100A" wouldn't look like a number to Excel. Off-hand I don't think you can get around the functions and helper columns.

If it's a repetitive task, you can write a program to sort it correctly and transparently—that is, to add the helping columns, do the sort and then delete the helping columns. That's even more work, but it's one-time work and after that you can do the task without having to set it up carefully. But other than that, I don't see a way.

Hi, there is something you can try:
In another column, place this formula: ="000"&A1 and copy down as needed (assuming your data starts from A1, change as needed)
After that, copy and paste as values the results of the formula; now you can sort this data, make sure you choose the option " sort numbers and numbers stored as text SEPARATELY".
If you want to return to the previous format of your data, remove the first 3 zero's with: =MID(C1;4;LEN(C1)-3), then copy paste as values...