Thread: quotation marks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default quotation marks

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" wrote in message
...
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!