Ok...I messed up....All of the lines don't say US Government Bonds....I was
just showing data layout. I should have been more specific. Every row says
something different in place of the US Government....
Sorry about that. Any other ideas?

Thanks


"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