Hello,
What's the formula to be used in this case please?
I have a list of transaction showing vendors and need to shorten the name based on a word
Examples:
If the cell is : POSTMATES TIP SAN FRANCISCO CA formula should translate as POSTMATES
If the cell is : POSTMATES BDC63 LA SAN FRANCISCO CA formula should translate as POSTMATES
If the cell is : COSTCO BY INSTACART SAN FRANCISCO CA formula should translate as INSTACART
If the cell is : GELSON BY INSTACART SAN FRANCISCO CA formula should translate as INSTACART
If the cell is : STAPLES BY INSTACART SAN FRANCISCO CA formula should translate as INSTACART
Thank you!
Bookmarks