Hi

I basically want to search for "-" from the right of a cell and take anything after the "-" (Not including the -)

See attached basic example. I've tried a whole host of search and right combos and don't seem to be getting what I need!!

Thanks

Right and search function.xlsx