No difference in this case except that mid is more flexible since it can be
used in all position while right or left do what they are named after so
maybe Biff and other always use mid for that reason


--


Regards,

Peo Sjoblom


"DOR" wrote in message
oups.com...
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?