I follow; thanks again, guys.

Rednelle


"Harlan Grove" wrote in message
oups.com...
Niek Otten wrote...
<RIGHT isn't the best choice

Is it right or isn't it? Please elaborate
...

RIGHT(x,LEN(x)-(p-1)) works, extracting the rightmost substring from x
beginning at char position p measured from the beginning of the string.
However, it's easier just to use MID(x,p,N), where N is very large (any
positve value that can be held in a long integer will work). It's
easier still in VBA, in which it'd just be MID(x,p).

There are other ways to do this.

=SUBSTITUTE(x,LEFT(x,p-1),"",1)

=REPLACE(x,1,p-1,"")

RIGHT may have a place, but it's not built in to many programming
languages because it's seldom needed. IMO, it only makes sense to use
it when the substring's starting position is relative to the end/right
of the string directly rather than as derived from a beginning/left of
string position.