So I have a list of over 2,000 rows each which contains one cell per row with a description that includes a products model. Each description is different, although many are alike. For example, row 1 would read: "blablabla of type model X blablabla" while row 2 will have: "blablabla type Y" (where Y is the model type but not use of the word "model" is made); and row 3: "blablabla model O blabla".
I need to remove all model information from each of the descriptions (i.e. cells in each rows) and have no idea how to make this task more manageable. I was thinking of separating each cell into different cells, so one cell per word, to help identify and remove/re-edit any model information. Then I would re-join all the cells via a concatenate type function.
Any ideas?![]()
Bookmarks