logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Insert an apostrophe (') in front of each formula in the selected cells

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Formulas  ›  9. Insert an apostrophe (') in front of each formula in the selected cells

This tool inserts an apostrophe (') in front of each formula in the selected cells, which turns them to text.

Note:
To turn the changed formulas to actual calculating formulas again, you can use the following tool from ASAP Utilities:
"Numbers & Dates » Change not recognized numbers (text?) to numbers"

Screenshots

Formulas  ›  9 Insert an apostrophe (') in front of each formula in the selected cells

Starting this tool


Download
Rebuild array formulas



Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us