Finding Quotation marks in Search function

[Guest]

I imported a member list into Excel in which I need to find any names or
addresses that have quotation marks (") in them. When I try use the search()
function it tells me the entry is invalid. Any ideas?

 

[Peo Sjoblom]

http://www.mvps.org/dmcritchie/excel/formula.htm#hasformula


you would need VBA if you want to filter for that


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Peo Sjoblom]

Oops! Sorry, wrong post, the VBA was for the show formula question

However this works for me

=SEARCH("""",A1)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[SteveG]

To find a " in a text string, you can use SEARCH("""",A1,1).

If you wanted you could use a formula like =SEARCH("""",A1,1)>0 i
Conditional Formatting and copy to the rest of your range to fill al
the cells containing quotation marks a color.

OR you could use the Auto Filter and select "Custom" and Contains " fo
your filter criteria.

Do you want to remove these from the data or just identify them fo
some reason?

If you could provide a little more info that would be helpful so yo
get the solution you are looking for.

Regards,
Stev

 

[Guest]

Thanks. That works.

 

[Guest]

Thanks. I only had one quotation mark within the double quotes which is why
it wasn't working for me.

Alan

 

[Guest]

The easiest way I have found around the " problem. Is that I ctrl+c a
"(quotation mark). I then Ctrl+f, then Ctrl+v. And I then have the " in the
find what, section.