FIND with RIGHT to return numbers from a string

[jndipworm]

Hello all, I've been struggling with a formula should be simple. I have a string of numbers that varies in length but has two " " spaces in the string. I need to find the last " " space in the string and return the numbers that follow. The numbers will be a combination of the following: XX.XXXXXX or XX or .XXXXXX. The numbers will vary every time. I've been trying =RIGHT(FIND(" ", in different combinations with no luck. I've attached a sample to show what I'm looking for.
Thanks in advance.

[samba_ravi]

A1=IFERROR(ROUND(TRIM(RIGHT(SUBSTITUTE(E1," ",REPT(" ",256)),256)),3),"")
Try this and copy towards down

[AlKey]

=TRIM(RIGHT(SUBSTITUTE(E1," ",REPT(" ",25)),25))+0

Row\Col	A	B	C	D	E
1	13.12566				0 3.375444 13.12566
2	14.15973				6 2.289082 14.15973
3	14.00000				6 -2.289082 14
4	15.56550				0 -0.9583464 15.5655
5	8.00000				31.3678 2.953307 8
6	0.12380				31.3678 -2.953307 .1238

[jndipworm]

I'm getting a #NAME? error with this formula. My version of excel is 2003.

[AlKey]

I'm getting a #NAME? error with this formula. My version of excel is 2003.

This is because of the IFERROR function which is not compatible with Excel 2003.

[jndipworm]

AlKey your formula works, thanks...

[AlKey]

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).