Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
quotation marks
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
quotation marks
It Worked!! Thanks a lot.
"Tom Ogilvy" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quotation Marks | Excel Discussion (Misc queries) | |||
Quotation Marks? | Excel Worksheet Functions | |||
Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
quotation marks | Excel Worksheet Functions | |||
Using quotation marks | Excel Programming |