Looking for a way to sort a range of cells that are text based that contain numbers.

Hi all.
I am very limited with my excel VBA skill levels and would love some help to a problem I am facing.
I have a spreadsheet that is pulling allocated points for individuals from other spreadsheets.
Because the formula returns a text based result, when sorting the numbers the results are 1,10,11,12,2,20,21 etc.

Is there away to sort the numbers in the text only low to high? the code I have used is also below.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

You could create helper columns next to each one you wish to sort. In the helper column you would have a formula that parses out the number from the text in the column next to it (using MID() and FIND() functions). Your VBA would then select the helper column and the one next to it, but using the helper column as the one to sort. You could hide the helper column so that it does not appear on your main view.

Great suggestion for adding helper columns but the cells are being moved sometimes prior to sorting so helper cells would be incorrectly referencing blanks. I think I could make this work though.