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!