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



"Peo Sjoblom" wrote in message
...
http://www.mvps.org/dmcritchie/excel...htm#hasformula


you would need VBA if you want to filter for that


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"ahearn" wrote in message
...
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?