Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - 'finding' a quote mark (") ???
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help - 'finding' a quote mark (") ???
Thanks very much.
Al. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula For Finding a Quotation Mark In a String | Excel Worksheet Functions | |||
Foot mark aka single quote mark? | Excel Worksheet Functions | |||
Quote "number count" | Excel Discussion (Misc queries) | |||
Eliminating the quote "This document was sent to the printer" | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) |