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.

Sir,

Yes! That's fine. Works great. There will always be one integer.

Thanks!!
Camil Sader, MD

Mr WHER

Also, brilliant! Thank you for your input and time spent on solving my problem.

Camil Sader, MD