Hi,
I have a column of text that I would like to split up by a couple of keywords. I've been trying to mess around with it using iif statements but I don't think that'll do it all. I have little experience with VBA and wouldn't know where to start.
This is what the column looks like.
|Fancy Navy Blue Polo|
|Solid Red Tee Shirt|
|Fancy Green Jacket|
I was hoping to split it up to look like this.
Fancy|Navy Blue|Polo
Solid|Red|Tee Shirt
Fancy|Green|Jacket
I was able to split the first word and last word in the column using excel. But, then I realized some were two words "Tee Shirt". Which made me think maybe I could use some IIf statements but then again realized how would I keep the "Navy Blue" (Center) in the column. I thought maybe if I could separate it with keywords? Or create a column that OMITS keywords?
Sorry, I'm kind of all over the place..... Maybe someone would have a suggestion or point me in a direction that could help.