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.
