Hey

I have a small problem that i cant seem to find out

i have a text string ex: Apple;House;Wine

I need a formual that returns the last 4 characters after the last ";"

I have tried using find combined with right / left, but cant seem to make it work

Thx in advance