Convert phone numbers with dashes in them to just numbers

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

Thanks. Jenny

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

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 <Toppers@discussions.microsoft.com>
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