search more than one character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
sorry! thought it didn't go trough

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula, Partial word, SUM function as result 1
How can I create a formula out of more than 7 functions in excel? 3
SUMDIVISION formula function - does it exist? 6
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
SEARCH function help 2
Search Entire Sheet instead of 1? 4
If Cell Contains specific UPPERCASE text 8
search array 3

Back
Top