Spell Check
Thank you so much for your help but I think I did not make myself clear.
Your code is working fine with 2 double quotes in a string but my text actually like this below with your guidance and I got the compilation error:

Dim strMyVariable
strMyVariable = "NEW Craftsman Microtork 3/8" Torque Wrench"
strMyVariable = Replace(strMyVariable, Chr(34), Chr(39))
MsgBox "Output :: " & Trim(strMyVariable)

However if I add one more double quote right after 3/8" (3/8"") then it working fine. Unfortunately my string have to be one single double quote.

So go back to the first question, How can I get rid off a single double quote in string text before and I can call a function Trim(strMyVariable), or some ways to work around it via VBScript? This is only language that I know and use now. I can't you VB.

Thank you so much in advance for helping me out since I stuck with coding and it seems I can go any further if this problem won't be solved unless I have to learn another language which is very hard for me.

Richard Myer


Note:
   "NEW Craftsman Microtork 3/8" Torque Wrench" can be any title with double quote stand for inch like this:
   "Brand New TV Sony 32" SRTVDV-Flat Panel"

Have a great day
Myer