Home > Big Data Analytics > Excel - Removing apostrophe (') at the beginning of my formula
Big Data Analytics

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

On February 21,2022 by

In this short article we will show you how to remove the apostrophes and calculate the formula at the same time in Excel.

Solution

The problem is that the presence of the apostrophe simply means that the content of your cells is Text.

So, you can use text to column option located under the "DATA" menu.

Leave a Reply

Your email address will not be published. Required fields are marked *