View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default How to stop Excel adding quotation marks when copying to notepad?

pretended :
On Monday, October 26, 2009 8:19:01 AM UTC-4, 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!)


I was able to get around this issue by highlighting all of my text in Excel,
Copying it, then open a new Wordpad document. In Wordpad go to Edit menu and
select "Paste Special" then choose "Unformatted Text" and hit OK. Next save
your Wordpad document as a text file. No more extra quotes.


Perhaps Excel thinks you're trying to create a tab delimited text file?

It would be much, much faster/easier/better to dump the data into an
array and write the data directly to a text file using standard VB file
I/O functions. No fuss, no muss, just pure data dumped into a plain
text file!

--
Garry

Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion