Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, there!
The situation goes like that : I have a messy cell that contains both adresses and a couple of phone numbers per client. The problem is that i need only the phone numbers. Is there a way that i can exctract each one of them in a different cell - i mean if this client has 3 numbers specified in the messy cell, they should be distributed in 3 separated cells. Also as you can guess the adresses includes numbers, that are not needed, and basically this can be worked around ( i guess ) by specifying that we need numbers with more that 5 digits. P.S. I`m not very advanced users, so I`ll apreciate detailed ( as for dummies ) explanation. Thanks in Advance, Georgi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting numbers and letters in a single cell to separate cells | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
Extracting single piece of data | Excel Discussion (Misc queries) | |||
can you count the number of letters (inc spaces) in a single sell | New Users to Excel | |||
Extracting data from a single cell | Excel Programming |