View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jean-Paul Viel Jean-Paul Viel is offline
external usenet poster
 
Posts: 39
Default Help - 'finding' a quote mark (") ???

Hi,



Use this function instead of the " : chr(34)




--
JP

http://www.solutionsvba.com


"astro_al" wrote in message
...
Hi - pretty easy one I hope:

I need to find the character " in a text string, but if I use a
function such as InStr, I have to put two of the same character around
the one I'm looking for - ie """ (what are they called, quote marks?).
So is there some way to differentiate between the quote marks required
for the function and the quote mark which I am searching for in the
line of text?

Thanks, Al.