=RIGHT(A2,LEN(A2)-42)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Luc in Oxford" wrote in message
...
I have a column of text which has 42 characters (which are the same) and
then
names of various clients. I'd like to get a formula to remove the first
42
characters and just give me the names of each client. I've tried with LEFT
and RIGHT, but to no avail.

Thanks for any help,

Luc