How to stop Excel adding quotation marks when copying to notepad?
On Monday, 26 October 2009 13:19:01 UTC+1, AI32768 wrote:
I'm just interested in stopping Excel adding quotation marks around text
pasted from copied cells into notepad without having to go into notepad and
do endless 'find and replace's afterwards.
Formatting the cells as text makes no difference so why is Excel adding the
quotes in only around cells containing IP addresses? (And putting a tab after
the first quote marks!)
Finally found a solution for this....!!
If you publish as web, and copy from, there (instead of from the GSheet directly), then it doesn't add the double quotation mark
Not ideal, but does the trick ;p
|