Problem 1. I have a column which contains
1. 5555/3/6/CBN
2. 988/2/3/CBN
3. 10889/2/11/ABCD
4. 0001/5/9/ABCD
5. 0400(C )R
6. AA-497(C)R
I want a formula which shows result like below:-
1. 3/6/CBN
2. 2/3/CBN
3. 2/11/ABCD
4. 5/9/ABCD
5. (C)R
6. (C)R
Please guys help me///////////
Bookmarks