Biff,

I notice that 3 different responders to this request suggest the MID
function with some high number of characters to return, rather than the
RIGHT function as in :

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

which seems to work well enough and doesn't need the catch-all value of
1,255 or whatever else.

Am I missing something, or does RIGHT have some obscure problem that
the experts are aware of and others are not?