Forum Discussion
Cannot Edit Result of a Formula In A Cell
I was editing the results of a formula in multiple cells in a column (=A1&""&B1) gives the result AABBCC301.79 (where A1=AABBCC and B1=301.79) . I wanted to remove the fractions so the result would ...
Thanks Hans for the reply,
That did not work. If A1=5.25 and B1=5.5, that formula returns 10 (no decimals - the point of INT, but when I enter the cell to edit the resulting number, it still only shows the formula.
If A1=AABBCC and B1=301.25 that formula using INT returns #VALUE! This is the formula I need to work - a combination of text from one cell and numbers in the other. I need to be able to edit the result so it reads AABBCC301
I also just noticed that I can no longer use Find and Replace to edit the result of a formula i.e. I cannot find AABBCC301.25 and replace it with BBCCDD301.25, I have to find A1 (AABBCC) and replace it with A2 (BBCCDD).
Using the formula =A1&B1:
Press F2 to edit the cell.
You will see the formula.
Select it in its entirety.
Press F9 to evaluate it.
Now you see the result.
Edit it as needed.
Press Enter.
Warning: this destroys the formula; only the edited result will remain.
