![]() |
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. |
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. |
Help - 'finding' a quote mark (") ???
Thanks very much.
Al. |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com