Removing concatenated colums after using them?

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

Guest

I used the concatenation formula to join first and last names together into a
new cell. However, I now need to delete the two original cells for
submission to a printer. Of course, when I do that, I get "REF" in the third
cell because the references used to perform the concatenation function have
disappeared.

Does anyone have any idea how I can send the file without the two original
cells?
 
Select the cell with formulas (concatenated cells), do edit>copy, then
edit>paste special and select values. Now you can delete the other 2 columns
 
Back
Top