Whats the best way to deliminate or separate numbers from a text and numbers cell?

The left and right functions cant work well cuz the numbers are not consistent. Plus I want to remove the numbers from the text string. TIA

E.G.

I've gotten this with some basic Google searching. Only issue is its not recognizing the decimal points.

This pulls the number out.

{=SUM(MID(0&A1,LARGE(ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*ROW(INDIRECT("1:"&LEN(A1))),ROW(INDIRECT("1:"&LEN(A1))))+1,1)*10^ROW(INDIRECT("1:"&LEN(A1)))/10)}

Post #6This pulls the text.

=TRIM(LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1))

Post #3