Hi everybody:

 

I have tried for find 2 separate words or letter strings in a record, but so far I can't figure out how to do it.

 

I have many product codes by color in 2 colored items.

For example "red23blue47"; same colors with different hues could be "red78blue55"

 

How can I find all the red and blue items, no matter the hue (indicated by a number).

 

I have no problem finding all the red or all the blue Ctrl+F *red* or Ctrl+F *blue*

 

I want to be able to find the red##blue##

I have tried everything I can think of:

Ctrl+F *red*blue*

Ctrl+F *red* Ctrl+N *blue*

 

But they don't give the results.

 

Any help is welcome,

 

Thanks

Carlos

For example "red23blue47"; same colors with different hues could be "red78blue55"

 

 

Try searching for:

 

red*blue*

 

or, if you want to be more accurate:

 

red##blue##

red##blue*

or

red##blue##

 

I was a little late

Thanks, it worked:

 

BROWN*YELLOW* yielded what I wanted:

 

BROWN25YELLOW7

BROWN49YELLOW73

BROWN7YELLOW209