View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jaime@isnottv.com is offline
external usenet poster
 
Posts: 1
Default 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