ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I search for more than one text character in one cell? (https://www.excelbanter.com/excel-worksheet-functions/26910-how-do-i-search-more-than-one-text-character-one-cell.html)

Dolores

How do I search for more than one text character in one 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("*"&J11&"*","*"&A1:A4&" *")),0)

Thanks for any help in andvance!


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com