Hi,

Now I understand the problem. I thought you meant that quotation marks were appearing in Excel, but you didn't - they're appearing in Notepad when you copy and paste from Excel. That makes sense, because Notepad can't parse some non-printing characters such as hard line breaks, so it adds quotation marks to ensure that a block of text is marked as belonging together.
The only way I can see to stop this happening is to remove the line breaks before the copy and paste. You can do this with Substitute (changing each line break into a space) or with Clean (removing all non-printing characters). Each has its advantages and disadvantages. Substitute might give you two spaces sometimes but will always give you a space; Clean will remove the space entirely, thus often running words together - it might also remove things in Excel which you don't want removed.
The formulae would be:
Formula: copy to clipboard 
=SUBSTITUTE(R2,CHAR(10),CHAR(32))&" . . . "&S2

or
Formula: copy to clipboard 
=CLEAN(R2 &" . . . "& S2)

or (if you only want to clear non-printing characters from column R)
Formula: copy to clipboard 
=CLEAN(R2) &" . . . "& S2


The results are:
Substitute:
Google . . . http://google.com/
"Google" . . . http://google.com/
Google row 3 . . . http://google.com/
Google "row 3" . . . http://google.com/
Clean:
Google . . . http://google.com/
"Google" . . . http://google.com/
Googlerow 3 . . . http://google.com/
Google"row 3" . . . http://google.com/

If you specifically need to use Concatenate, you could use Substitute or Clean within that formula.

Hope that helps.

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.