Thanks, Niek; and thanks, Harlan

I'll try both.

Rednelle



"Harlan Grove" wrote in message
oups.com...
Niek Otten wrote...
Hi Rednelle,

=RIGHT(A1,LEN(A1)-1)
...

When the position at which to break strings is measured from the
beginning or left side of the string, RIGHT isn't the best choice.

=MID(A1,2,1E9)