Getting formula of another cell in target cell

excel formulas
Pupper picture Pupper · Feb 3, 2012 · Viewed 70.9k times · Source

How does one cell obtain the formula of another cell as text without using VBA? I can see this question has already been asked many times and the answer is always to write a custom function in VBA.

However, I found a post made in 2006 which claimed to have found the non-VBA solution but the link provided in that post is already broken.

Answer

Excel User picture Excel User · May 9, 2014

=FormulaText(Reference) will do the trick Documentation

Related questions

Comparing two columns, and returning a specific adjacent cell in Excel

I am using a combination of if, vlookup, match, iserror functions, and unfortunately I've not been able to find the right formula. Comparing two columns for matches is easy enough. the tough part has been returning a specific cell once …

Read More
HTML to Excel: How can tell Excel to treat columns as numbers?

I need to achieve the following when opening an HTML in Excel (Response.contentType="application/vnd.ms-excel") : force Excel to consider content of td cells as numbers make the above so that any subsequent user-entered formulas work on these cells (…

Read More
Transposing data from column to row using references

I have some data in a row, say A1 to Z1, and I would like to link to this data in another spreadsheet. However I would like to transpose it so the data runs from A1 to A26. It is …

Read More