Excel and Notepad: how avoid additional inverted commas after copy and paste?

Excel Help for Excel And Notepad: How Avoid Additional Inverted Commas After Copy And Paste? in Developing and Auditing Analytical Models

Excel And Notepad: How Avoid Additional Inverted Commas After Copy And Paste?

Rate this: (3/5 from 1 vote)

	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 __________________ http://www.idee-regalo.biz/catalogo-stereogrammi-3.html http://www.ghisirds.it/ http://scuo.la/ http://www.righettofabrizio.com/pantografo-taglio-plasma.html
	Posted by ghisirds on 11 Sep 2007

Replies - Displaying 1 to 2 of 2

Order Replies By: Most Recent | Chronological | Highest Rated

	Several possible solutions Rate this: (3/5 from 1 vote) There could be several possibilities: Do and Edit/Replace in Notepad to remove or replace the unwanted characters. Paste into Wordpad instead. Paste Special into Wordpad or another text editing application.
	Excel Business Forums Administrator
	Posted by Excel Helper on 12 Sep 2007

solution Rate this: (3/5 from 1 vote) thanks to all! I solved the problem and it is work. Sub TestMacro() Dim objClip As DataObject ' Microsoft Forms 2.0 Object Library ' needs to be selected as a Reference (on the VBA Tools menu) Dim strTmp As String Set objClip = New DataObject strTmp = Replace(ActiveCell.Value, Chr(10), vbCrLf) objClip.SetText strTmp objClip.PutInClipboard Set objClip = Nothing End Sub best regards.

Posted by ghisirds on 13 Sep 2007

Displaying page 1 of 1