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?

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?

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?

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 in
Conditional Formatting and copy to the rest of your range to fill all
the cells containing quotation marks a color.

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

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

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

Regards,
Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540703

Thanks. That works.

"SteveG" wrote:


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 in
Conditional Formatting and copy to the rest of your range to fill all
the cells containing quotation marks a color.

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

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

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

Regards,
Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540703

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

Alan

"Peo Sjoblom" wrote:

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?

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.
--
inthestands


"ahearn" wrote:

Thanks. That works.

"SteveG" wrote:


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 in
Conditional Formatting and copy to the rest of your range to fill all
the cells containing quotation marks a color.

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

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

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

Regards,
Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=540703