breaking reference to a cell
Posted by Robin McNeely on September 20, 2000 9:50 AM
I have concatenated the text from 3 separate cells into
a new cell. I would like to have the newly created text
in that cell become the real values that they are, not
references to the 3 cells that they were created from.
My goal is to delete the 3 original cells and just have
the concatenated data. Is there a way in Excel to do
this?
Posted by Tim Francis-Wright on September 20, 0100 6:18 PM
Copy the offending cell, then use the Paste Special
command, and select the Values option. You
can paste back in the same place if you don't
need to keep the formulas.
HTH
