Menu

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




Issue


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.

Thanks ton rizvisa1 for this tip.

Related

Published by aakai1056. Latest update on April 23, 2012 at 08:24 AM by aakai1056.
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 (https://ccm.net/).
Copy Data to Another Workbook in Excel
Excel - Copy row and insert n times