Hi
I have a cell where if the first 21 characters of the cell contain the text "###eWindow Add-on to " then I would like to take everything to the right of the last space in that phrase.
So if cell A1 had "###eWindow Add-on to Market Insight - Agriculture Package" then cell B1 would return "Market Insight - Agriculture Package"
If cell A2 has "###eWindow Add-on to Market Insight - Oil Package" then cell B2 would return "Market Insight - Oil Package"
Has anyone done this before, please?
###eWindow Add-on to Market Insight - Agriculture Package
I have a cell where if the first 21 characters of the cell contain the text "###eWindow Add-on to " then I would like to take everything to the right of the last space in that phrase.
So if cell A1 had "###eWindow Add-on to Market Insight - Agriculture Package" then cell B1 would return "Market Insight - Agriculture Package"
If cell A2 has "###eWindow Add-on to Market Insight - Oil Package" then cell B2 would return "Market Insight - Oil Package"
Has anyone done this before, please?
###eWindow Add-on to Market Insight - Agriculture Package