Forum Discussion

Rich9454a's avatar
Rich9454a
Copper Contributor
Feb 24, 2021

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 ...
Excel
Formulas and Functions
Macros and VBA
  • Rich9454a's avatar
    Rich9454a
    Copper Contributor
    Feb 24, 2021

    HansVogelaar 

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

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 25, 2021

      Rich9454a 

      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.

Resources