Excel formula to text with FORMULATEXT, TEXT, and apostrophe methods

User question

how to convert excel formula to text

Artificial Intelligence Response

Direct answer to the question

To convert an Excel formula to text, use one of these methods depending on what you mean:

Goal	Best method
Show the formula itself as text	=FORMULATEXT(A1)
Turn a formula into plain text in the same cell	Add an apostrophe before =
Convert formula result to a fixed value	Copy → Paste Special → Values
Convert a numeric/date result to formatted text	Use TEXT()
Temporarily display all formulas	Press `Ctrl + ``

---

Detailed problem analysis

1. Convert the formula itself to text

If cell A1 contains:

=SUM(B1:B10)

and you want another cell to display the formula as text, use:

=FORMULATEXT(A1)

Result:

=SUM(B1:B10)

This is useful for documentation, auditing, or checking formulas.

Important notes:

• FORMULATEXT() works in Excel 2013 and later.
• If the referenced cell does not contain a formula, Excel returns #N/A.
• The original formula remains active and still calculates.

Example:

Cell	Formula/content	Displayed result
A1	=SUM(B1:B10)	calculated value
C1	=FORMULATEXT(A1)	=SUM(B1:B10)

---

2. Convert a formula to text in the same cell

If you want to stop Excel from calculating the formula and show it as plain text, put an apostrophe before the equals sign:

'=SUM(B1:B10)

Excel will display:

=SUM(B1:B10)

The apostrophe tells Excel: “treat this as text.”

This is best for manually converting individual formulas.

---

3. Convert many formulas to text at once

For bulk conversion:

1. Select the cells containing formulas.
2. Press Ctrl + H to open Find and Replace.
3. In Find what, enter:

=

4. In Replace with, enter:

'=

5. Click Replace All.

This changes formulas like:

=A1+B1

into text like:

'=A1+B1

Excel will display:

=A1+B1

Be careful: this disables the formulas. The cells will no longer calculate.

---

4. Convert the formula result to a fixed value

If you do not want the formula text, but instead want to replace the formula with its calculated result:

1. Select the formula cells.
2. Press Ctrl + C.
3. Right-click the same cells or another destination.
4. Choose Paste Special → Values.

Example:

Original formula:

=A1+B1

If the result is 25, after Paste Special → Values, the cell contains:

25

The formula is removed.

This is the best method when you want to freeze calculated results.

---

5. Convert the result to formatted text

If your formula produces a number or date and you want the result as text, use TEXT().

Examples:

=TEXT(A1,"0.00")

Converts a number to text with two decimal places.

=TEXT(A1,"$#,##0.00")

Converts a number to currency-formatted text.

=TEXT(A1,"yyyy-mm-dd")

Converts a date to text.

Important distinction:

=TEXT(A1,"0.00")

does not show the formula inside A1. It converts the calculated value of A1 into a text string.

---

6. Temporarily show formulas without converting them

If you only want to view all formulas in the worksheet:

Ctrl + `

The grave accent key is usually above Tab or below Esc on many keyboards.

You can also go to:

Formulas → Show Formulas

This does not convert anything. It only toggles the display between formula results and formulas.

---

Practical guidelines

Use this decision guide:

• If you want to display a formula as text in another cell, use:

=FORMULATEXT(A1)

• If you want to turn the formula itself into plain text, add an apostrophe:

'=A1+B1

• If you want to keep only the calculated result, use:

Copy → Paste Special → Values

• If you want to format a calculated number/date as text, use:

=TEXT(A1,"format")

---

Brief summary

The most common solution is:

=FORMULATEXT(A1)

if you want the formula itself as text.

Use an apostrophe before the formula if you want to disable it:

'=SUM(A1:A10)

Use Paste Special → Values if you want to replace the formula with its result.

Disclaimer: The responses provided by artificial intelligence (language model) may be inaccurate and misleading. Elektroda is not responsible for the accuracy, reliability, or completeness of the presented information. All responses should be verified by the user.