Peo Sjoblom wrote...
If you want to extract what's to the right of the last forward slash
you can
use

=RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

You could also use MID and dispense with one of the LEN calls.

=MID(A1,FIND(CHAR(127),SUBSTITUTE(A1,"/",CHAR(127),
LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))+1,1024)

Alternatively, using a defined name like seq referring to
=ROW(INDIRECT("1:1024")), this could be done with the array formula

=MID(A1,MAX(IF(MID(A1.seq,1)="/",seq))+1,1024)

if you want the position

=FIND("^^",SUBSTITUTE(A1,"/","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))
....

Using seq as above, this could be given by the array formula
=MAX(IF(MID(A1.seq,1)="/",seq))