Freeze Function Results in Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Select the columns with the formulas right click copy, right click paste
special, and select values
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
custom data validation on cells with data validation values 2
VBA set thick borders around non empty cells in range 0
Excel code, end function? 0
search function 2
Copy corresponding cell in Column B if cell in A contains certain text? 1

Back
Top