Freeze Function Results in Cells
 

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!

Freeze Function Results in Cells
 

Select the columns with the formulas right click copy, right click paste
special, and select values
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Tyler Shillig" wrote:

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!