How to Find a " or other special character?

PDuPre' · May 20th, 2002, 11:36 AM

Trying to find a quotation mark using the find or search formulas. Can't seem to find any reference to this in Help or in the history on this web site.

Would appreciate this hopefully simple little answer.

Thanks!

Philip

Asala42 · May 20th, 2002, 11:40 AM

Hey,

to find a: "

=FIND("""",A2) ...(that's 4 " btw)

to find a: '

=FIND("'",A2)

Hope that helps,
Adam

[ This Message was edited by: Asala42 on 2002-05-20 10:41 ]

[ This Message was edited by: Asala42 on 2002-05-20 10:42 ]

PDuPre' · May 20th, 2002, 11:44 AM

Thank-you. I've been playing around with that for too long.

Thanks for the quick solution.

Philip

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 11:36 AM	#1
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	Trying to find a quotation mark using the find or search formulas. Can't seem to find any reference to this in Help or in the history on this web site. Would appreciate this hopefully simple little answer. Thanks! Philip

May 20th, 2002, 11:40 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,028	Hey, to find a: " =FIND("""",A2) ...(that's 4 " btw) to find a: ' =FIND("'",A2) Hope that helps, Adam [ This Message was edited by: Asala42 on 2002-05-20 10:41 ] [ This Message was edited by: Asala42 on 2002-05-20 10:42 ]

May 20th, 2002, 11:44 AM	#3
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	Thank-you. I've been playing around with that for too long. Thanks for the quick solution. Philip