Hey everyone,
I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to be a single cell formula if that is possible.
Thanks a lot in advance and if you have any questions please aske them!
I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to be a single cell formula if that is possible.
| Book1 | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | Text | Formula goes here: | List of keywords: | |||||
| 2 | asdasas red asdassadassa green asdasasd green asdasdsa purple asdadasd red | Red, Green, Green, Purple, Red | Red | |||||
| 3 | sdadsa green | Green | Green | |||||
| 4 | asdasasd purple asdasd red | Purple, Red | Yellow | |||||
| 5 | asdasd Yellow Red | Yellow, Red | Purple | |||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 | ||||||||
Sheet1 | ||||||||
Thanks a lot in advance and if you have any questions please aske them!
