quotation marks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a process that determines if a cell contains a certain character
values. The list of values is identified as all the values inside quotation
marks (example: "*[!@'#$%^&]*"). I now need to include the quotation marks in
the list but do not know how to write it. I also need to include the single
tick as an exclusion.
Thanks in advance for any help!
 
if that is a string or if you are using it as an argument to like then

"*[!@'#$%^&""]*"

(double the double quote)
 
It Worked!! Thanks a lot.

Tom Ogilvy said:
if that is a string or if you are using it as an argument to like then

"*[!@'#$%^&""]*"

(double the double quote)

--
Regards,
Tom Ogilvy




Hippy said:
I have a process that determines if a cell contains a certain character
values. The list of values is identified as all the values inside quotation
marks (example: "*[!@'#$%^&]*"). I now need to include the quotation marks in
the list but do not know how to write it. I also need to include the single
tick as an exclusion.
Thanks in advance for any help!
Click to expand...
Click to expand...
 
Back
Top