| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I search for more than one text character in a cell? | Excel Worksheet Functions | |||
| How do I search for more than one text character in one cell? | Excel Worksheet Functions | |||
| Is it possible to search for the "?" character | Excel Worksheet Functions | |||
| FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
| Search for a specific character in a cell in an if statement | Excel Worksheet Functions | |||
Linear Mode
