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.
Solution
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.
This document, titled « Excel - Removing apostrophe (') at the beginning of my formula », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
