ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy value of the cells but not formatted one (https://www.excelbanter.com/excel-discussion-misc-queries/194891-copy-value-cells-but-not-formatted-one.html)

Pascal.Landry

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 !

Pascal.Landry

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 !



All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com