Thread: Excel add quotes when copy/paste text in notepad

I'm not sure why that's happening for you. It doesn't for me.

Perhaps you could post a sample workbook with the data that ends up with quotes around it.

Regards

The square symbols are the carriage return/line feed characters that you have inserted to force the names onto separate lines. Notepad is unable to interpret them. The quotes are to ensure that all the characters are treated as one "item"

Regards

I guess this relates to the format of the data. If you copy and paste "simple" text, you don't get quote marks.

The Carriage Return/New Line/Form Feed/whatever is character 10.

If you substitute the Carriage Return for some other character, you can copy and paste the text and not get quotes ... but you still won't get the data appearing as it does in the Excel cell.

For example:

=SUBSTITUTE(A1,CHAR(10),"|")

will give you:

Mana Burtner|Zack Radzavich|Ranee Minger|Margarito Bede|Carmel Shum|Alonzo Jefferis|France Dehetre|Russ Slauson

and this pastes into Notepad as:

Mana Burtner|Zack Radzavich|Ranee Minger|Margarito Bede|Carmel Shum|Alonzo Jefferis|France Dehetre|Russ Slauson

Notice that there are no quote marks and no square blocks.

Hope this helps.

Regards

Try...the code

Sub ptest()
    Dim lname As String

    Open ThisWorkbook.Path & "\stuff.txt" For Output As #1
    lname = Replace(Range("A1").Value, Chr(10), " ")

    Print #1, lname
    Write #1, lname
   
    
    Close #1
End Sub

Not sure why this thread has taken on a new lease of life. It started in May last year with a couple of replies and, as far as I can see (or recall), no response from the OP (in the thread, PM or rep).

Perhaps the re-awakening is as a result of the recent improvements on the board?


Regards, TMS

True, did not notice the date . I'll lock the thread