'check any one of a word of a list is present in a string (without space) using excel formula [duplicate]
I need to check if in a given cell exists any one word from a list
Example :
I have tested using all options in https://www.exceldemy.com/return-value-if-cells-contain-certain-text-from-a-list/ However, none of them working since my string doesnt have a space
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|