Forum Discussion
Solved
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...
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 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 That was the magic bullet. Thank you very much!