Removing apostrophe (') from the beginning

Solved/Closed
Duffy - Apr 22, 2012 at 12:18 PM
 Duffy - Apr 22, 2012 at 01:27 PM
Hello,


I have an excel sheet where I have formulas with an apostrophe in the beginning.

Example:

'+34+54+56+22
'+34+222+224+556
'+92+922+12+42

I have one column with about 3000 of these.

Is there any way to remove the apostrophes AND calculate the formula at the same time? If I try to use the CLEAN() function, I have to copy and paste the formula as values. This causes the apostrophe to appear again.

Best regards,

Duffy
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 22, 2012 at 12:33 PM
that apostrophe is saying that cell is a text

You can use text to column option that you see under "DATA"
0
Thanks! Works like a charm!
0