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

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 bu...

excel

Formulas and Functions

Riny_van_Eekelen
Jan 21, 2023
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?

Riny_van_Eekelen

Platinum Contributor

Jan 21, 2023

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?

bonhed13
Copper Contributor
Jan 21, 2023
Riny_van_Eekelen That was the magic bullet. Thank you very much!

Forum Discussion

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

Resources