Try using Char(34)
e.g.
="Some text "&CHAR(34)&"spoonpilot"&CHAR(34)&" more text"