Hi!

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

No, not really. Using RIGHT is perfectly acceptable but consider these
differences (and this is what separates the "experts" from the rest of us!):

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

That formula contains 7 function calls and takes 86 keystrokes.

=MID(A1,FIND("~",SUBSTITUTE(A1,"/","~",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))))+1,255)

This formula has 6 function calls and takes 82 keystrokes.

Biff

"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?