Thread
:
Removing concatenated colums after using them?
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
external usenet poster
Posts: 3,268
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?
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom