Freeze Function Results in Cells

T

Tyler Shillig

I have a column of data that was created as a concatenation of 2 other
columns. However, I'm reformatting the document for another purpose, and I
no longer need the 2 other columns, but when I attempt to delete them, I end
up with a #REF error in every one of the cells in the first column. Is there
a way that I can freeze the data in the first column's cells to make it
static and independent of the data in the other two columns? Thanks for your
help!
 
J

John Bundy

Select the columns with the formulas right click copy, right click paste
special, and select values
 
Top