Hello

I need help on some coding, I am given reference numbers such as SS/Y00034/7500. I need to find a way to search each cell and copy the last few digits up to the "/" and then paste into a different cell. The reference numbers are not always the same length, some are five digits, some are eight.

Is this possible to do?
If so could anyone help me or point me in the right direction to look

Many thanks

Martin