Excel - Removing apostrophe (') at the beginning of my formula

October 2016


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.

Related :

This document entitled « Excel - Removing apostrophe (') at the beginning of my formula » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.