ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Help - 'finding' a quote mark (") ??? (https://www.excelbanter.com/excel-programming/276065-help-finding-quote-mark.html)

astro_al

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.

Jean-Paul Viel

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.




astro_al[_2_]

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