LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get rid of squares substituting as spaces in excel? JJ Excel Worksheet Functions 2 October 15th 07 10:23 PM
Excel cells change color after reopened peopleflo Excel Discussion (Misc queries) 2 June 15th 06 07:02 PM
Hyperlinks in Excel database don't work when file is reopened. Anne Tarctica Excel Discussion (Misc queries) 0 May 7th 06 05:03 PM
csv format drops a text character when reopened in Excel RivRunR Excel Worksheet Functions 1 July 29th 05 06:16 PM
removing squares and lines in squares that really should be paragr finnadat Excel Discussion (Misc queries) 5 February 10th 05 11:12 PM


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"