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:
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.
"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