Extracting numbers from a single sell
First of all I would like to say Merry Christmas to all of you that
are celebrating it and thanks for the input !
@ Per : the only separators are spaces so TextToColumns, will give me
10 cells with different information, so again I need a way to select
only the ones that I need ( the cells with phone number )
@ Gary, @ Ron : here is the content of a exemplary cell :
adr:Sofia, P.K. 1715 Druzhba district 4 flat 407 entrance 6 floor 6
apartment 38 9754543 0898892158 9754543 000
The numbers that we need are 9754543 ; 0898892158 ; 9754543,
everything else is needless, i.e. the phone numbers contains between 5
and 10 ( maybe in some case more ) digits without spaces or dashes in
it. Also the number of phone numbers provided can vary, i.e. the cell
can contain 1,2,3,4,5 different numbers that we should extract.
I`m really confused and I`ll be really grateful if you can help me.
Thank you in advance !
Georgi
|