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

[Peo Sjoblom]

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?

[Teethless mama]

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?

[Jin]

"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