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 apostrophe in excel
- How to remove ' in excel - Best answers
- Remove apostrophe in excel - Best answers
- How to remove false in excel ✓ - Forum - Office Software
- Remove false from excel ✓ - Forum - Excel
- Need help to remove FALSE from cell ✓ - Forum - Office Software
- Removing False Value ✓ - Forum - Excel
- How to remove formatting in excel - How-To - 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).
