In column A I have number codes as follows:
1234/8
45673/18
4672/294
In column B I want formula which will isolate and provide me with the number on the right of the "/" so the answers in column B would be
8
18
294
I know I have use text to columns but need a formula that saves me doing that...