=--MID(A7,SEARCH("us government bonds",A7)+20,255)

=FIND(" ",A7)
finds the first space (directly before the "US Government...")

You want to find the last space character (or use a different method).



Dan B wrote:

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

--

Dave Peterson