Removing concatenated colums after using them?

K

Karen Stull

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?
 
P

Peo Sjoblom

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
 

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

Concatenate cells with line breaks in them 4
concatenate values 4
concatenate dynamic ranges 7
deleting columns used in concatenate function 1
Concatenate 3
evaluate a concatenate expression 3
Use concatenated text as name in formulas 2
Concatenate not working 3

Top