Replace Function

D

DNA

I've used this feature a lot, but can't seem to get this task
accomplished...

I have a column with numbers, but the first character is an apostrophe
('). I want to removed this character from this column so I can format
the column successfully.

Thoughts?? Thanks for your help!
 
P

PCLIVE

In a helper column, try:

=SUBSTITUTE(A1,"'","")

Copy down as needed.
Then copy the helper column and using 'Paste Special' ->Values, paste the
date back to the original column.

Regards,
Paul
 
K

Kassie

Hi DNA

In a helper column, say with your data in A2, enter the formula =A2*1

That will convert it from text to numbers
 
R

RagDyer

Simply open and close TTC.

Select the column of numbers, then:
<Data> <TextToColumns> <Finish>

And you're done!
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
D

DNA

Yep, that one worked as well, Can't figure out why I didn't think of some
of these.

Thank you ALL so much for your help!
 
J

Jason Clement

You could also enter a 1 into another cell, highlight that cell and copy it
(ctrl+c or edit->copy), then select your cells containing the apostrophe and
select edit->paste special from the menu, select multiply as the operation,
and hit OK.
 
Top