=--MID(A7,FIND("~",SUBSTITUTE(A7," ","~",LEN(A7)-LEN(SUBSTITUTE(A7,"
",""))))+1,99)

--
HTH

RP
"Dan B" wrote in message
...
Hi,

My data is as follows, all in one cell:

10015200 US Government Bonds 18,369,423.52
10012301 US Government Bonds 10,232.21

There are many varying lengths of digits. I am trying split off the
numbers
to the right of US Government Bonds into another column. Here is my
formula:
=RIGHT(A7,IF(ISERROR(FIND(" ",A7)),LEN(A7),FIND(" ",A7)))

My result is 9,423.52. Its not pulling the whole number.

What do I need to change in the formula?

Thanks