TEXTAFTER Formula showing result in dialog box but shows formula in cell.

[bonhed13]

I am trying to copy a number at the end of a text entry to another cell. 

• BASIC LAP CHOLE INSTRUMENTS 2 - C1956

Using the TEXTAFTER formula, the dialog box returns the correct result

but the cell in the sheet just produces the formula.

I do not have show formulas engaged in any of the sheets for this workbook. Please, someone, anyone, stop the madness and help me.

[#2 · Accepted solution]

@bonhed13 I suspect that the column is formatted as Text. Change it to General, select the cell with the formula. Press F2 and then Enter.

Does that fix it?

[#3]

@Riny_van_Eekelen That was the magic bullet. Thank you very much!