Formatting a cell to show just calculated value?

  • Thread starter Thread starter Emily Steed
  • Start date Start date
E

Emily Steed

I have alpha characters in Column AA, numeric values in Column AB, and a
formula in Column B to combine the two. The formula is: =AA2&AB2. For
example, if the value in Column AA is XYZ, and value in Column AB is
789, the formula will place XYZ789 into B2.

Question: How can I format B2 after the formula has placed XYZ789 into
the cell, so there isn't the above formula, rather, I would like it to
show only XYZ789 because I do not wish to send Columns AA and AB with
the spreadsheet.

TIA for ideas/solutions.
 
Emily

You cannot format the cell but you can Copy>Paste Special>Values>OK>Esc.

If you want to keep the original formulas, just copy the worksheet or the
columns/rows to another blank sheet and use the Paste Special when dropping
the data.

Gord Dibben Excel MVP
 
Back
Top