On Tue, 27 Dec 2005 23:28:58 +1030, OZDOC1050 wrote:

part 1
in k6 place this and drag down
=LEFT(H6,FIND("/",H6,1)-1)
in l6 place this and drag down
=RIGHT(H6,LEN(H6)-FIND("/",H6,1))

This works fine!

Thanks!