Excel - Changing Text to Formulas

If like us, you often find yourself using Excel to write Excel formulas, you’ll have undoubtedly struggled to make the text you generate into formulas. This post shows you how...

  • Use your wicked Excel skills to build the formulas you need. Concatenation, filling series and so on are your friends here! Remember the = at the start of each formula...
  • Paste (as Values) the text into the cells you want to contain the generated formulas
  • Highlight the range of cells with the text in and Replace = with = in all these cells
  • Close the Replace dialog and - Excel re-parses the text and finds the formulas.

We take no responsibility for any hints and tips we provide here, but they are provided in good faith hoping to help our friends and colleagues.



Groves Systems Ltd
Making Excel work for you...