Hi Folks,
Let's say I have these words in Column A (A1:A4)
Green Apple
Red Apple
Yellow Banana Cute
Green Banana
How is the code or formula be written if I want to get Apple & Banana return in B1:B4?
B1 = Apple
B2 = Apple
B3 = Banana
B4 = Banana
Thanks so much
Let's say I have these words in Column A (A1:A4)
Green Apple
Red Apple
Yellow Banana Cute
Green Banana
How is the code or formula be written if I want to get Apple & Banana return in B1:B4?
B1 = Apple
B2 = Apple
B3 = Banana
B4 = Banana
Thanks so much