search more than one character
 

Hi!
I am looking to find a way how I can search for more than one character out
of a existing column. I have tried to set a formula but somehow something is
wrong...
e.g. =MATCH(TRUE,ISNUMBER(SEARCH("*"&J11&"*","*"&A1:A4& "*")),0)

I thank for any help that I can get in advance!

Dolores

This makes at least three posts with the same question. It's been answered.
See the answer from Peo to your 2d post.

"Dolores" wrote:

Hi!
I am looking to find a way how I can search for more than one character out
of a existing column. I have tried to set a formula but somehow something is
wrong...
e.g. =MATCH(TRUE,ISNUMBER(SEARCH("*"&J11&"*","*"&A1:A4& "*")),0)

I thank for any help that I can get in advance!

Dolores

sorry! thought it didn't go trough

"Duke Carey" wrote:

This makes at least three posts with the same question. It's been answered.
See the answer from Peo to your 2d post.

"Dolores" wrote:

Hi!
I am looking to find a way how I can search for more than one character out
of a existing column. I have tried to set a formula but somehow something is
wrong...
e.g. =MATCH(TRUE,ISNUMBER(SEARCH("*"&J11&"*","*"&A1:A4& "*")),0)

I thank for any help that I can get in advance!

Dolores