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