CONCATENATE adds quotes - How to suppress?

If you use 'Paste Special' to paste unformatted text into Word, you'll get the same quotation marks as you get in Notepad. Essentially, any program which can't handle formatting marks / non-printing characters will give you the same result - by choosing 'unformatted text' you can force Word to behave like this too. The default paste in Word 'understands' the line break from Excel so retains it. Notepad (and other similar programs) don't understand the line break so either ignore it entirely or indicate to the user that there's a 'not-understood' character in the pasted string, by putting quotation marks around the string.

Basically, what I'm saying is that what's happening is by design in Notepad and I don't think there's anything you can do to 'fix' it. Sorry.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

=CONCATENATE(SUBSTITUTE(R2, CHAR(10), CHAR(32)) & " . . . " & S2)

CHAR(32) = SPACE . . . http://www.lookuptables.com/

Doesn't work.
This replaces the Line Feeds with a Space, which gets rid of all the extra quotes from when I copy and paste,
but, I need the Line Feeds . . . and now the text has a lot of extra Spaces