Formula Errors

Fix a TEXTAFTER Formula Displayed as Text in Excel

John WilsonJohn Wilson Nov 18, 2026 870 views

Question details

The user needs a TEXTAFTER formula to display its calculated result in the worksheet cell.

Fix a TEXTAFTER Formula Displayed as Text in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user enters a TEXTAFTER formula to extract text after a delimiter.
Observed behavior
The formula dialog shows the expected value, but the worksheet cell displays the formula as text. Show Formulas is not enabled.
Before you start

Select the affected cell and check its number format on the Home tab. Confirm that Show Formulas is off and that the formula dialog displays the expected result.

Solution 1Recommended

Change the cell format and re-enter the TEXTAFTER formula

Use this method when the formula cell or its column is formatted as Text.

1
Select the formula cell

Click the cell displaying the TEXTAFTER formula. If other formula cells in the column have the same issue, select those cells as well.

2
Change the format to General

On the Home tab, open the Number Format drop-down and select General.

3
Re-enter the formula

Select the formula cell, press F2, and then press Enter. Alternatively, click the formula bar and press Enter. Repeat for each affected formula cell.

4
Check the formula prefix

In the formula bar, make sure the formula starts with an equals sign, such as =TEXTAFTER(A1,"-"). Remove any leading apostrophe, then press Enter.

Change the cell format and re-enter the TEXTAFTER formula
Changing the format alone is not enough: A formula already stored as text usually needs to be re-entered after the cell format is changed to General.
Free Microsoft Office alternative

Work with spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open Excel files and continue working with a straightforward transition; check formula compatibility when using newer Excel functions.

Open and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting and formula-editing controlsWork in a free, lightweight office suiteMove existing Office documents into a familiar workspace
microsoft office alternative - wps office

Frequently Asked Questions

Why does my TEXTAFTER formula show in the cell instead of its result?

The cell may have been formatted as Text when the formula was entered. On the Home tab, change its number format to General, then edit the formula and press Enter.

Why didn't changing the cell format to General fix the formula?

Excel may still store the existing entry as text. Select the cell, press F2, and press Enter, or click the formula bar and press Enter to re-enter it.

Can an apostrophe make a formula appear as text?

Yes. A leading apostrophe tells Excel to treat the entry as text. Select the cell, remove the apostrophe in the formula bar, and make sure the formula begins with an equals sign.

Where can I check whether Show Formulas is enabled?

Open the Formulas tab and check the Show Formulas button. If it is enabled, click it to display calculated results instead of formulas.