Excel and Notepad: how avoid additional inverted commas

ghisirds · Rated PG Joined: 10 Sep 2007 Posts: 1

Hi,
If I write a multi-line text in a cell (then go down with alt+enter) and after copy the cell pasting on Notepad, it display before inverted commas and after textual content.
Instead, if I select directly the content from the formula bar, it isn't happen.
Do exist a way for copy and paste directly from the cell without select from the formula bar?
Maybe with a macro?

Thank
Marco

javajeff · Rated PG-13 Joined: 04 Dec 2007 Posts: 27

I do not know exactly what you are trying to do, but did you ever consider using a better text editor? PSPad is excellent, and then you could save a document as a CSV to open in Excel. I know of the problem that you are having it is very common.