Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy value of the cells but not formatted one
In a work procedure, I use this format "SQL "@ to define some SQL statements
that user must do. The problem I have is whenever we copy the cell, to paste it in a third party software, the value that is pasted is including the format section "SQL " which I don't want. Is there a way to keep Excel from taking this as the actual value of the cell ? Users won't want to copy from the formula bar cause it takes one more clic to get there (long procedures...) and also since value in the cell might be very long... Anyone knows how to do this ? It would be very appreciated ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy value of the cells but not formatted one
Anybody as an idea ?
Thanks "Pascal.Landry" wrote: In a work procedure, I use this format "SQL "@ to define some SQL statements that user must do. The problem I have is whenever we copy the cell, to paste it in a third party software, the value that is pasted is including the format section "SQL " which I don't want. Is there a way to keep Excel from taking this as the actual value of the cell ? Users won't want to copy from the formula bar cause it takes one more clic to get there (long procedures...) and also since value in the cell might be very long... Anyone knows how to do this ? It would be very appreciated ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell data as formatted | Excel Discussion (Misc queries) | |||
Excel 2007: copy/paste formatted cells? | Excel Discussion (Misc queries) | |||
Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
Converting 'General' formatted cells to Text formatted cell using. | Excel Worksheet Functions |