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/pant...io-plasma.html

Here is the way to extract contents

Sub Extract_Text()

Dim oWB As Workbook
Dim lRow As Long


Set oWB = ActiveWorkbook


Open "c:\Temp.txt" For Append As 1
For Each SHT In oWB.Sheets
 lRow = SHT.Cells.SpecialCells(xlCellTypeLastCell).Row
 For l = 2 To lRow
    Print #1, Trim$(SHT.Cells(l, 2).Value)
 Next l
Next SHT
Close #1

oWB.Close False

End Sub

You need to tweak a bit for the range

Cheers
Shasur

http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

In the meantime, thank you for the reply but Notepad was an example.
Really I must paste the cell content on other programs that operate as Notepad.
Then the contents without inverted commas have to stay only on clipboard.
Is it possible?
Thank you very much!
Marco