Mecheltheka
New Member
- Joined
- Aug 15, 2020
- Messages
- 21
- Office Version
- 2007
- Platform
- Windows
Good morning,
Let's say that there are 10 rows and 1 column in a table and i want to find a word in this table. So, i would like to find a function, in order to scan the whole table and finally to return "true" if this word exist or to return "false" if the word doesn't exist. I don't care about the name of this cell.
Postscript: I tried something, like this: ISNUMBER(SEARCH("Text",B21:B31)), but it doesn't work!
Let's say that there are 10 rows and 1 column in a table and i want to find a word in this table. So, i would like to find a function, in order to scan the whole table and finally to return "true" if this word exist or to return "false" if the word doesn't exist. I don't care about the name of this cell.
Postscript: I tried something, like this: ISNUMBER(SEARCH("Text",B21:B31)), but it doesn't work!