Extracting specific phrases from a cell and echoing them in another

by Brian L   Last Updated August 13, 2019 17:03 PM

Longtime learner, first time poster here!

I was wondering if anyone knew how to extract specific data points (phrases) from a Google Sheets cell and echo in another cell.

enter image description here

For instance, In my example I have Vehicle year/make/model/trim etc. all in my "B" column. I would like to be able to extract for instance the trim into it's own column. So for instance I would need the formula to search for "XL", "XLT", and "STX" and if one of those was found, then echo that exact phrase out in another cell.

I would and can post a few things I have tried, but I honestly haven't gotten very close yet. Mostly ended up echoing out the complete cell value or #NA

Also please note that the format for the original cell might change so an ideal solution would not rely on the information being sandwiched between two "known variables" and instead simply search for specific variables and echo those when found :)

Any help would be much appreciated!

Tags : google-sheets

Related Questions

Updated March 03, 2018 02:03 AM

Updated September 19, 2018 13:03 PM

Updated June 10, 2019 17:03 PM

Updated July 26, 2018 21:03 PM

Updated November 29, 2018 16:03 PM