removing everything from the left after 10 digits
 

I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212

so in columns 2 and 4 I would like to strip off the 9 and 1

I do not have alot of programming exp.

thanks for your help

The "Right" function would probably be useful for this. Ie =right("Cell
reference",10)

Regards,

Adam Wood

"tri_p" wrote:

I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212

so in columns 2 and 4 I would like to strip off the 9 and 1

I do not have alot of programming exp.

thanks for your help

On Thu, 29 Sep 2005 22:40:02 -0700, "tri_p"
wrote:

I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212

so in columns 2 and 4 I would like to strip off the 9 and 1

I do not have alot of programming exp.

thanks for your help

with phone numbers in column B starting in B1, put in A1

=IF(LEN(B1)<=10,B1,RIGHT(B1,LEN(B1)-(LEN(B1)-10)))


HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

That worked PERFECT (which I'm sure you knew that it would)

Thank you so much!!!

"Richard Buttrey" wrote:

On Thu, 29 Sep 2005 22:40:02 -0700, "tri_p"
wrote:

I have a column of phone numbers. I would like to "strip" off everything
after 10 digits ie1: 5555551212 ie2: 95555551212 ie3: 5551212 ie4: 15555551212

so in columns 2 and 4 I would like to strip off the 9 and 1

I do not have alot of programming exp.

thanks for your help

with phone numbers in column B starting in B1, put in A1

=IF(LEN(B1)<=10,B1,RIGHT(B1,LEN(B1)-(LEN(B1)-10)))


HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________