Remove left text string

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>