Need code to pull numeric data out of an alphanumeric string (string not constant)

Hello Excel Gurus,

Need your help with pulling some numeric data out of a string with alphanumeric text. I am having trouble using a command like "RIGHT" because the size and format of the string is not constant. What I mean is that the number of characters prior to or preceeding the data I need is not always the same. I still need the non-numeric text, I just need it seperated into a different column.

So, what I really would need is the following in the attached spreasheet.

1) In column B, I need the actual rate, which is only the NUMERIC information contained in column B already.
2) In column C, I need all the NON-NUMERIC text that proceeds the NUMERIC information that is currently in column B.
3) All information that follows the NUMERIC information in column B can be discarded.

So, right now, this is and example of what you see in column B - Variable 0.03947 kwh

What I would need is something like this:

Column B: 0.03947
Column C: Variable

Any help would be GREATLY appreciated.

Thanks for all your help.

Harry

Worked perfectly.

Thanks!