Copy value of the cells but not formatted one

P

Pascal.Landry

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 !
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Can you lock the value of a cell but not the format? 1
Copy cell data as formatted 2
format cells depending on value range 5
conditional formatting based on the value of another cell 8
Number format not being recognized when pasting value 2
Excel 2007: copy/paste formatted cells? 2
inserting a hyperlink into a conditionally formatted cell, Excel 2 2

Top