Hi,
I am working on an excel sheet for a project and needs to pull multiple words from a cell.
Example:
ABD Chevrolet Buick Cadillac - Need to pull the brand names (Chevrolet, Buick, Cadillac) and place in a single cell. If not possible, 1 brand each cell.
GHM Buick and GMC - pull "Buick" and "GMC" to a cell
Do i need to make a reference table with all the brands for this to work?
I've tried and search a couple of functions but nothing seems to work.
Thanks in advance!
Bookmarks