[ create a new paste ] login | about

Link: http://codepad.org/v77f62x8    [ raw code | fork ]

Plain Text, pasted on Aug 22:
1
2
3
4
5
6
7
8
9
10
11
Cell B1:
=RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

Cell C1:
=LEFT(B1,FIND(".",B1)-1)

Or, if you want to do it all in one cell:
=LEFT(RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))),FIND(".",RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))))-1)


Make sure to substitute A1/B1 for the correct cell location


Create a new paste based on this one


Comments: