View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?