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.