Return answer dependant on /

Hi guys last question today

in cell d1 i have

hk/q46559

in cell i1 i need to return whatever is before the "/"
in this case hk

and in cell i2 i need to return the number after the q
in this case 46559

thanks once again

Look at LEFT/RIGHT/MID/FIND/SEARCH functions

I1: =LEFT(D1,FIND("/",D1)-1)
I2: =RIGHT(D1,LEN(D1)-(FIND("/",D1)+1))

Hi excellentexcel,

Cell I1:

Please Login or Register  to view this content.

Cell I2:

Please Login or Register  to view this content.

HTH

Robert