View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MDG MDG is offline
external usenet poster
 
Posts: 1
Default saved Excel as .txt then reopened - now I have squares

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??