Tips: How to convert cells with formulas into raw text?

*** A new version of this article is available on this page ***

Sometimes you need to retrieve data from another source (spreadsheet, CRM etc.) before starting your mail merge. To do so, you might have used a special add-on, or a formula from Google Sheet such as 'Vlookup'.

Therefore, your spreadsheet may be filled with columns containing a lot of heavy formulas, which can cause trouble to Yet Another Mail Merge:

To make sure that you won't have any issues with sending emails, the best thing to do before using YAMM is to delete the formulas so that your spreadsheet contains only values (or raw text).

Select the column(s) that contains formulas, copy it, and paste its values only:

Your column should now be devoid of formulas: