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

=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

Fantastic! That worked a treat. Thanks a lot.

"Bob Phillips" wrote:

=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