-
Solved: Formula to help identify specific words in titles?
I am looking for the best way to identify colors in titles and then if a color is identified put that color name into a separate column. Multiple colors could be included in the same cell, separated by a comma. If no color exists then the cell if left blank.
For example:
Product Name #1: Cosmos Green & White case for Samsung Gravity
Product Name #2: Cosmos Green case for Samsung Gravity
(List of colors: white, blue, green, black, yellow, red, purple)
A1: Product Name | A2:Colors
Product #1 name | Green , White
Product #2 name | Green
Any ideas for how best to accomplish this?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules