Prev: File in Exclusive Use
Next: Mirror View
From: sidm via OfficeKB.com on 19 May 2010 11:56
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 copy>paste in my column.
>> Thanks!

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

First  |  Prev  | 
Pages: 1 2
Prev: File in Exclusive Use
Next: Mirror View