Hello, I'm fairly new to macros. Looking to export an excel sheet to a text file. I don't want the file to contain the quotes that excel applies to cells containing sentences/text. I figured that out with this thread:
http://www.excelforum.com/excel-gene...ut-quotes.html
This works great, but one problem. I have multiple lines within a single cell (alt + enter). When this exports, notepad shows the "enters" as a square symbol, all on one line. Can any one help me to fix this and make appear as a new line, like how it shows in excel? Even if I just paste these multi-line cells into notepad, same thing happens.
Thanks
Bookmarks