sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
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 every time
thanks
Seamus
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 every time
thanks
Seamus