Pull numbers with decimal from text range and copy to single cell with commas

Hi all,

I am looking for a formula based solution that will allow decimal numbers to be pulled from a range of cells. I want the numbers to to be copied to a single cell and seperated by commas. The following layout is what I had in mind if anyone is able to offer help with this:

Sample data:
A1 721.0 Cervical spondylosis w/o myelopathy
A2 Closed FX of C6 vertebra 805.06
A3 952.03 C1-C4 level with central cord syndrome

Desired output:
B1 721.0, 805.06, 952.03

Thank you for any help that you may be able to provide.

Patrick

Hi again,

I need a little bit of help with this formula. It wasn't exactly what I set out to accomplish but it will do the trick once I can get it to overlook blank reference cells. I will just let the users know they have to follow the format and all should be good.

Anyway, The 2nd and 3rd reference cells will most times be blank. Currently the formula does not allow for this. What do I need to change to allow for the blanks to be overlooked? The 1st reference will always have a value.

=LEFT(Form!B9,FIND(" ",Form!B9))&", "&LEFT(Form!B10,FIND(" ",Form!B10))&", "&LEFT(Form!B11,FIND(" ",Form!B11))


Thanks for your help,

Patrick