Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I search for more than one text character in a cell?
I have a column with different names in one row. And one cell where it could
be that one of the names of the column can be shown. My goal is to find a way how to search for this one word in the cell... I've tried... but I got an error and I don't know which one! e.g.: MATCH(TRUE,ISNUMBER(SEARCH("*"&J5&"*","*"&Specs!$S 2:$S14&"*")),0)) I really do appreciate any help and thank in advance! |
#2
|
|||
|
|||
=MATCH(TRUE,ISNUMBER(SEARCH(J58,Specs!$S2:$S14)),0 )
array entered with ctrl + shift & enter however you can use countif =COUNTIF(Specs!$S2:$S14,"**&J58&"*")0 regards, Peo Sjoblom "Dolores" wrote: I have a column with different names in one row. And one cell where it could be that one of the names of the column can be shown. My goal is to find a way how to search for this one word in the cell... I've tried... but I got an error and I don't know which one! e.g.: MATCH(TRUE,ISNUMBER(SEARCH("*"&J5&"*","*"&Specs!$S 2:$S14&"*")),0)) I really do appreciate any help and thank in advance! |
#3
|
|||
|
|||
Thanks for advise!
But somehow this does not work as it showes me an #N/A error... Dolores "Peo Sjoblom" wrote: =MATCH(TRUE,ISNUMBER(SEARCH(J58,Specs!$S2:$S14)),0 ) array entered with ctrl + shift & enter however you can use countif =COUNTIF(Specs!$S2:$S14,"**&J58&"*")0 regards, Peo Sjoblom "Dolores" wrote: I have a column with different names in one row. And one cell where it could be that one of the names of the column can be shown. My goal is to find a way how to search for this one word in the cell... I've tried... but I got an error and I don't know which one! e.g.: MATCH(TRUE,ISNUMBER(SEARCH("*"&J5&"*","*"&Specs!$S 2:$S14&"*")),0)) I really do appreciate any help and thank in advance! |
#4
|
|||
|
|||
Additional I have to note that in column "J5" there are more than one word -
it's a row of words Dolores "Dolores" wrote: Thanks for advise! But somehow this does not work as it showes me an #N/A error... Dolores "Peo Sjoblom" wrote: =MATCH(TRUE,ISNUMBER(SEARCH(J58,Specs!$S2:$S14)),0 ) array entered with ctrl + shift & enter however you can use countif =COUNTIF(Specs!$S2:$S14,"**&J58&"*")0 regards, Peo Sjoblom "Dolores" wrote: I have a column with different names in one row. And one cell where it could be that one of the names of the column can be shown. My goal is to find a way how to search for this one word in the cell... I've tried... but I got an error and I don't know which one! e.g.: MATCH(TRUE,ISNUMBER(SEARCH("*"&J5&"*","*"&Specs!$S 2:$S14&"*")),0)) I really do appreciate any help and thank in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search for more than one text character in one cell? | Excel Worksheet Functions | |||
Search a Column by text length | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
How do I search for text within text? | Excel Discussion (Misc queries) |