Where did that I come from<g

Gotta get new eyes one of these days.


Gord
On Thu, 22 Jun 2006 20:46:01 -0700, Toppers
wrote:


For 281-333-3333 -

=TRIM(SUBSTITUTE(A1,"-",""))

For I281-333-3333 - (with prefix of I )

=TRIM(SUBSTITUTE(RIGHT(A1,(LEN(A1)-1)),"-",""))

HTH

"J H" wrote:

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny