| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula to extract a phone# from a cell of text (eg classified)?
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
Hi!
You need to provide some samples. Biff "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! |
|
#4
|
|||
|
|||
|
Doesn't work with any type of formatted telephone number.
Plus, that want ad would probably have addresses, which negates the *single* number requirement. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Max" wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula for IF a cell CONTAINS certain text... | Excel Worksheet Functions | |||
| Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
| Text in Cell as Formula | Excel Discussion (Misc queries) | |||
| How to copy a formula as text to another cell? | Excel Discussion (Misc queries) | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Linear Mode
