Hi Dave,
I formatted the column to number and did the replace method, works fine for
me.By far your method is the easiest.

Dave Peterson wrote:
Maybe you could select the range to fix
Edit|replace
what: _R_2 (_ represents a space character)
with: (leave blank)
replace all

But when I did this, I ended up with text -- not a number.

I have this in my column:
858+00.000 R 2
[quoted text clipped - 13 lines]
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1