Unable to pull numbers (variable lengths and periods) out of cells

Good Morning,

I have a filed that is imported into excel from another database. It imports with number headings in the same cell as the text. I would like to be able to pull the numbers out of the text cells and place them in column A. I have attempted to use the Mid, Left and Text to Columns methods, but the numbers are different lengths and have Periods (.) within them as well. Also, there are some Rows that do not contain any numbers, so I would want to leave them as is. I am sure that I am missing something easy, but I can't figure it out.

I have attached a sample workbook for viewing.

Here is a quick example of what appears in Column A when the file is imported:

23.********** Review and analyze current and deferred tax assets and liabilities
23.1.2************* Analysis of current and deferred income tax asset and liability accounts for each of last three years and most recent interim period, including any provisions made for aggressive filing positions and tax audit issues


Thank you in advance for your help.

Thank you TMS! That is great! that works awesome.

Is there a way to "delete" those numbers from the cell that its pulling them from? So, only the text is left in the original cell?

Thanks again for your quick help... much appreciated!

Thats great! Thank you again for your help!

have a great day