N Neil T Aug 12, 2004 #1 How can I write a formula to search a text cell for quote marks (")? FIND and SEARCH don't accept " as an argument (Excel 2002)
How can I write a formula to search a text cell for quote marks (")? FIND and SEARCH don't accept " as an argument (Excel 2002)
J JE McGimpsey Aug 12, 2004 #3 As with any other string function in XL, you need to double the quote marks when within quotes, e.g.: =FIND("""",A1) alternatively, you can use CHAR() =FIND(CHAR(34),A1)
As with any other string function in XL, you need to double the quote marks when within quotes, e.g.: =FIND("""",A1) alternatively, you can use CHAR() =FIND(CHAR(34),A1)
