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 them in another cell.
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
STX and if one of those is 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
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" but instead simply search for specific variables and echo those when found.
Any help would be much appreciated!