Replace Function
 

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!

Replace Function
 

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

"DNA" wrote in message
lkaboutsoftware.com...
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!

Replace Function
 

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

--
ve_2nd_at. Stilfontein, Northwest, South Africa


"DNA" wrote:

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!

Replace Function
 

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!
==============================================


"DNA" wrote in message
lkaboutsoftware.com...
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!

Replace Function
 

Worked perfectly, thank you!

Replace Function
 

Wow, very smart, that worked great as well!

Thank you very much!

Replace Function
 

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!

Replace Function
 

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.


"DNA" wrote:

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!