Search anywhere in cell

[Deborah Mowry]

I have a cell that contains reference numbers. Most are 1 but some contain
up to 3 entries (it was not created properly a long time ago). However; I
wish to query where there is a particular reference and I only get it IF it
is the first one entered.
Specifically -
Possible entries are in a few records would be:
PO18
PO12, PO14, PO18
PO14
PO02, PO18
PO18, PO09

I queried for *"PO18"* and it would only return the first and last record,
not the second and fourth!
If I wanted a last name containing Donald I would have typed *Donald* and
got MacDonald and Donaldson, therefore I am not understanding what happened
here.
Deborah

 

[Fredg]

As criteria for the field:
Like "*PO18*"

A better way is to NOT hard code the criteria.

Like "*" & [Look For] & "*"

You will be prompted to enter the words.

 

[Deborah Mowry]

I would never have thought to try that - thank you.
Do you have an explanation for why it would not search as a query? Or is
that too hard to explain?

Many thanks
Deborah

As criteria for the field:
Like "*PO18*"

A better way is to NOT hard code the criteria.

Like "*" & [Look For] & "*"

You will be prompted to enter the words.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

I have a cell that contains reference numbers. Most are 1 but some contain
up to 3 entries (it was not created properly a long time ago). However; I
wish to query where there is a particular reference and I only get it IF it
is the first one entered.
Specifically -
Possible entries are in a few records would be:
PO18
PO12, PO14, PO18
PO14
PO02, PO18
PO18, PO09

I queried for *"PO18"* and it would only return the first and last record,
not the second and fourth!
If I wanted a last name containing Donald I would have typed *Donald* and
got MacDonald and Donaldson, therefore I am not understanding what happened
here.
Deborah