Fix a TEXTAFTER Formula Displayed as Text in Excel
Question details
The user needs a TEXTAFTER formula to display its calculated result in the worksheet cell.

- 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.
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.
Change the cell format and re-enter the TEXTAFTER formula
Use this method when the formula cell or its column is formatted as Text.
Click the cell displaying the TEXTAFTER formula. If other formula cells in the column have the same issue, select those cells as well.
On the Home tab, open the Number Format drop-down and select General.
Select the formula cell, press F2, and then press Enter. Alternatively, click the formula bar and press Enter. Repeat for each affected formula cell.
In the formula bar, make sure the formula starts with an equals sign, such as =TEXTAFTER(A1,"-"). Remove any leading apostrophe, then press Enter.

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.

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.




