Hi Everyone,
I need some help with a formula that I think is possible but I'm not sure.
Scenario:
Cell A2 = blue nike womens running shoes
Cell B2 = nike
Cell C2 = running shoes
So, I have a phrase (A2) and I have extracted the the 2 main words into two separate cells (B2 & C2).
What I 'm looking for is a formula that will extract the remaining words into a 3rd column/cell (D2)
In this case, Cell D2 = blue womens
-------------------------------------------------------------------------------------------------------------------------------------------------------
Ideally, I'd like to extract the remaining words into separate columns/cells as well, 1 for the words that appears before B2 and 1 for words that appear after C2
In this scenario if A2 = 'blue nike womens running shoes on sale', D2 = 'blue' & E2 = 'on sale'
The first part is what I really need, so that's what I'm mostly concerned with. the 2nd part is just a wish.
All replies will be greatly appreciated.
Thanks!
Bookmarks