Remove left text string

L

Luc in Oxford

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
 
B

Bob Phillips

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

--

HTH

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

Luc in Oxford

Fantastic! That worked a treat. Thanks a lot.

Bob Phillips said:
=RIGHT(A2,LEN(A2)-42)

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top