Quotation Marks In String

K

Ken Snell

Double them up.

Dim strString As String
strString = "Guy ""ACCESS-MAN"" Rondeau"
Debug.Print strString

Above will show you the resulting string:
Guy "ACCESS-MAN" Rondeau
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mark-as-read problem 0
Inability to add quotation mark around a variable by concatenation in VBA 4
Formula For Finding a Quotation Mark In a String 0
Automatic indexing in footnotes - solved 0
How to copy only the numbers that are between quotation marks in new cells 1
problem with automatic quotation marks 1
Change Smart Quotes To Dumb Quotes 3
Quotation Marks as Text 2

Top