Use the following formulae:
D2: =MID(A2,4,FIND("/",A2)-5)*1
E2: =MID(A2,FIND("/",A2)+2,3)
F2: =RIGHT(A2,LEN(A2)-FIND("/",A2)-4)*1
Hope this helps.
Pete
Use the following formulae:
D2: =MID(A2,4,FIND("/",A2)-5)*1
E2: =MID(A2,FIND("/",A2)+2,3)
F2: =RIGHT(A2,LEN(A2)-FIND("/",A2)-4)*1
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks