Published on

Convert formula to simple text in Google Sheets

Your blog post starts here.

Edit > Find and Replace or (Ctrl + H)

Select "Also search within formulas"

Search = and replace with a empty space

This should convert any formulas in your selected range in simple text, removing the = at the beginning of the cell.

If you have another = somewhere in your text, better use regex. "Search using regular expressions" explore that option from the "Find and replace" popup.