Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenated lookup? | Excel Worksheet Functions | |||
appearance of a concatenated value | Excel Worksheet Functions | |||
Lookup for concatenated data | Excel Discussion (Misc queries) | |||
warning with concatenated date | Excel Discussion (Misc queries) | |||
concatenated text to formula | Excel Discussion (Misc queries) |