View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Stull Karen Stull is offline
external usenet poster
 
Posts: 1
Default 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?