View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default saved Excel as .txt then reopened - now I have squares

I've never seen anything like this.

I wonder if those double quotes were actually smart quotes (curly style that
MSWord uses).

If so, it might be easier to just fix those characters by making a couple of
changes inside NotePad.



MDG wrote:

I have an Excel document that includes a list of e-mail addresses as well as
other data. This was saved as a .txt file. When reopened, the double quotes
that were inserted by Notepad are apparently not recognized by Excel and so
show up as squares. Not sure if Notepad separates columns using the double
quotes, but it seems that way and so I don't have much control over it. Any
thoughts about fixing this OR a way to resave so that the quotes don't show
up to begin with??


--

Dave Peterson