I have an Excel sheet where I have formulas with an apostrophe in the beginning.
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.
The presence of the apostrophe simpy means that the content of your cells is a Text.
You can use text to column option located under the "DATA" menu.
Thanks ton rizvisa1 for this tip.
Published by aakai1056
Latest update on April 23, 2012 at 08:24 AM by aakai1056.