Convert numbers stored as text to numbers for range of data that changes

I have about 5000 rows of data and column G has variations in numbers and letters. Some have purely 7 numbers others have numbers and letters in random orders. The data (pure numbers) comes to excel stored as text and it would be extremely tedious to go through and convert each to the number format. I am wondering what an easy way to do this because I tried going to format cell>number and it still comes with the error to change to number. I later want to make a macro if possible to simplify this process so if thats possible that would be great otherwise maybe just a formula? I uploaded a sample workbook Book1.xlsx

Hi, try copy column G data to notepad.
Then copy back the data from notepad to column G.


_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin

That seems to have done it, I also went to format cell and changed back to general. Thanks!