Excel - Removing apostrophe (') at the beginning of my formula
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.
Related
- How to remove ' in excel
- Remove ' in excel - Best answers
- What does apostrophe mean in excel - Best answers
- Remove formatting excel - How-To - Excel
- Remove author excel - How-To - Excel
- If-THEN function remove value excel ✓ - Forum - Office Software
- How to remove formula bar in excel - How-To - Excel
- How to remove false in excel ✓ - Forum - Excel
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 (ccm.net).
