One way .. Try RagDyeR's array formula at:
http://tinyurl.com/awha9
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Reuel" wrote in message
...
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!