Extract the integer

Greetings,

Below is a snapshot of data in a column. I need a way to extract the number, may be a whole, may be decimal, and leave behind the text description. Result to be put into a new column:

Hernia Umbilical 553.1
Perirectal Abscess 566
Diverticulitis 577.0
553.21 Hernia Vental/Incisional
Abdominal Pain RUQ789.01
Abdominal Pain RLQ789.03
217: Benign Breast mass
541-appendicitis
Chronic 575.11 Cholecystitis
SBO560.81
786.05SOB
226/ Thyroid neoplasm

The idea here is that the integer could be integrated in anyway imaginable with the associated text. I don't need the text. The end result must display this in a new column:

553.1
566
577.0
553.21
789.01
789.03
217
541
575.11
560.81
786.05
226

I am not technical with Excel at all, so please be gentle.

Thanks
Camil Sader, MD

Mr. Ote

You are a genius. It works very well. That is exactly what I needed but I need you to test your formula on this:

Hernia Uni 550.90

I want the output to be 550.90 and not 550.9

Possible?
Camil Sader, MD

Sounded great till I did it. There is a conflict. Watch this:

Hernia 550.90 is in A1
I need 550.90 extracted
550.9 gets extracted into B1
Change the decimal to 2
You get 550.90
Great!

The conflict:
Delete the A1 cell and enter:
Rectal Abscess 566
I need 566 extracted
566.00 gets extracted into B1
566.00 is an invalid code for medical billing (no such code)
Therefore there is a huge difference between 566 and 566.00
That's a difference between getting the claim paid vs. rejected.
Have I made you say 'uncle' yet?

Camil Sader, MD

Far less elegant than Don's/Richard's formula, but it seems to handle the ".90" problem.