=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.
--
HTH...

Jim Thomlinson


"pgarcia" wrote:

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