Removing concatenated colums after using them?
 

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?

Removing concatenated colums after using them?
 

Select the cell with formulas (concatenated cells), do editcopy, then
editpaste special and select values. Now you can delete the other 2 columns

--
Regards,

Peo Sjoblom



"Karen Stull" <Karen wrote in message
...
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?

Removing concatenated colums after using them?
 

Copy Paste Special Value OK


"Karen Stull" wrote:

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?

Removing concatenated colums after using them?
 

"Teethless mama" wrote:

Copy Paste Special Value OK


"Karen Stull" wrote:

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?


copy - value - paste special - values