Need to pick up data from left of a space starting from the right?

[pgarcia]

1 4210210 134.40
2 30362920 395.40
3 820401-2 116.20
4 728435514 5152.06
5 820401-1 194.57
6 820501-1 365.90
7 42111438 1158.50

I need to find the space from the right to left then bring back left of that
mark to the right.

Should look like this:
134.40
395.40
116.20
5152.06
194.57
365.90
1158.50

Thanks

 

[Duke Carey]

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))*1

delete the "*1" at the end if you really want a text value & not a number

 

[pgarcia]

If I use that I get "#VALUE!". If I remove the "*1" I get "4210210 134.40".
Does it matter if A1 is a fomula? =OFFSET(A1, MATCH("Line#Number
AmountReason For Difference",A:A, FALSE), 0, 1,1).
I also just used "1 4210210 134.40", but I get the same results.

But I think you just gave me a work around. I did this.
Cell B2 =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Cell C3=RIGHT(B1,LEN(B1)-FIND(" ",B1,1))
What do you think?

 

[Jim Thomlinson]

=VALUE(MID(A2, FIND(" ", A2), 256))
where the string in in A2

Or you could use Data -> Text to Columns to split the values apart.