capturing phone numbers help

I can't figure out how to use @Text properly.

Lets say A1 has text of (318) 123-4567

and I want to put a formula in A2 to capture only the numbers and store them
as 3181234567 in A2.

A1 is not formatted, its just text.

This can't be very hard, how to do??
Thx mucho !!

Mark

Try this formula:
=text (concatenate(mid(A1,2,3),mid(A1,6,3),right(A1,4)),"0000000000")

or
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B2,"(",""),")",""),"
",""),"-","")

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Mark" <d@zap.com> wrote in message news:93pGf.2255$Nq1.1427@dukeread11...
>I can't figure out how to use @Text properly.
>
> Lets say A1 has text of (318) 123-4567
>
> and I want to put a formula in A2 to capture only the numbers and store
> them
> as 3181234567 in A2.
>
> A1 is not formatted, its just text.
>
> This can't be very hard, how to do??
> Thx mucho !!
>
> Mark
>
>

On Wed, 8 Feb 2006 10:35:24 -0600, "Mark" <d@zap.com> wrote:

>I can't figure out how to use @Text properly.
>
>Lets say A1 has text of (318) 123-4567
>
>and I want to put a formula in A2 to capture only the numbers and store them
>as 3181234567 in A2.
>
>A1 is not formatted, its just text.
>
>This can't be very hard, how to do??
>Thx mucho !!
>
>Mark
>

If you happen to have Longre's free morefunc.xll add-in, available at
http://xcell05.free.fr/

you could use the simple formula:

=REGEX.SUBSTITUTE(A1,"\D")

This will remove every character that is not a digit.




--ron