logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 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"

Starting this tool


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



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


Empowering Excel Users Worldwide for 25 Years