Hi,

here are some other ideas:

=IF(COUNTIF(A1,"*d*")0,"Y","N")

or

=IF(COUNTIF(A1,"*"&F1&"*")0,"Y","N")

where F1 has whatever you want to search for

If you are willing to have the results display as True or False instead of
Y, N

=COUNTIF(A1,"*d*")0

You can search for any string by just replacing the d with whatever..

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"HS" wrote:

is there a way to say to create a column that displays a Yes or No if part of
a field has some text in it

for example if you wanted to tag the ones that had a D in column A

ColumnA Tag
abc N
abde Y
abcd Y
Thanks!