Remove left text string

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cut the last 20 characters out of a text string 4
Formula to validate characters within a string of data in aparticular cell 1
Text to columns 2
Reomving a set numer of characters from a text string 3
pulling certain characters from a string of text 3
Re: Formula to Remove Special Characters 5
How can this Micro customized. Please help 4
Formula to return a value for a portion of a text string in a cell 2

Top