The question is this:
I have fiew strings that i have to
extract text from.
JOHNNIE WALKER BLACK.CY
JOHNNIE WALKER BLACK 200ML/FL.CY
JOHNNIE WALKER BLACK 1.75L.CY
CY means - Current Year
For the first two I have a formula
which works fine:
O9 is where the string is.
It returns just the name without CY,
exactly what I need.
But on the 3 one it wouldn't work
because it has 2 periods.
I need a universal formula for any
size of the string, which will extract
me just the name. CY is constant on