Find the Value from the Cell

[AVG123]

Dear Friends today i am facing a new problem, please help me...............

I have a column

Column A

1. 1234/abcd
2. 4567/1/2/abcd
3. dp-400(c)
4. dp-7000(c)r
5. 5236/2/10/abcd

(Formula 1 ) i want a formula which shows the result write below:-
1.
2. 2/abcd
3.
4.
5. 10/ndmc

(Formula 2) i want a second formula which shows the result write below:-
1.
2. 2
3.
4.
5. 10

[zbor]

Formula 1:

If data is in A13 put formula in B13

Please Login or Register  to view this content.

[zbor]

Formula2:

If above formula is in B13 put in C13:

Please Login or Register  to view this content.