ExcelBanter - searching a cell for a contained text word

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - searching a cell for a contained text word (https://www.excelbanter.com/charts-charting-excel/31558-searching-cell-contained-text-word.html)

Doug K

searching a cell for a contained text word

Is it possible to search a cell for a key word or words contained in text
made of multiple words enabling the user to than create a pivot table using
the collected key word or words as data?
Doug K

All times are GMT +1. The time now is 09:12 AM.