Reformatting Cells
 

I have this in my column:
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2

859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
etc.. This progresses all the way to 1350+00 R 2. All I want to do is
remove the R 2 at the end, but keep the number. There must be a faster way
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

Reformatting Cells
 

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.

On 05/19/2010 08:31, tommygun715 wrote:
I have this in my column:
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2

859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
etc.. This progresses all the way to 1350+00 R 2. All I want to do is
remove the R 2 at the end, but keep the number. There must be a faster way
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

Reformatting Cells
 

EXCEL 2007

Assuming that your first, "number" is in cell A1 type the following in B1:-

=LEFT(A1,10)

Copy the above down column B.

If my comments have helped please hit Yes.

Thannks.






"tommygun715" wrote:

I have this in my column:
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2

859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
etc.. This progresses all the way to 1350+00 R 2. All I want to do is
remove the R 2 at the end, but keep the number. There must be a faster way
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

Reformatting Cells
 

Hi,

You could select this column then use

Data|Text to Columns

When running the wizard you may be able to get away with using 'Fixed Width'
or perhaps using space as a delimiter, it would depend on what the rest of
your data looked like.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"tommygun715" wrote:

I have this in my column:
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2

859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
etc.. This progresses all the way to 1350+00 R 2. All I want to do is
remove the R 2 at the end, but keep the number. There must be a faster way
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

Reformatting Cells
 

=SUBSTITUTE(A1," R 2",)


"tommygun715" wrote:

I have this in my column:
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2
858+00.000 R 2

859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
859+00.000 R 2
etc.. This progresses all the way to 1350+00 R 2. All I want to do is
remove the R 2 at the end, but keep the number. There must be a faster way
than deleting the R 2 in the formula toolbar, then copypaste in my column.
Thanks!

Reformatting Cells
 

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