0
Thanks

A few words of thanks would be greatly appreciated.

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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Related

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/).

0 Comments