Formula to extract a phone# from a cell of text (eg classified)?

[Reuel]

I have tried and tried... I'm looking for a formula to extract a phone
number out of an adjacent cell - eg, extract phone num from a cell containing
a want-ad description. Any ideas? thanks much!

 

[Max]

One way .. Try RagDyeR's array formula at:
http://tinyurl.com/awha9

 

[Biff]

Hi!

You need to provide some samples.

Biff

 

[Ragdyer]

Doesn't work with any type of formatted telephone number.
Plus, that want ad would probably have addresses, which negates the *single*
number requirement.