any one correct this single formula to extract 10 digits mobile number

[Prasad K]

this single formula is working there is a problem this formula is extracting only one 10 digit Mobile from starting i want to extract all 10 digit number to separate cells


=MID($A$1,(FIND("Phone:",$A$1)+LEN("Phone:"))+1,(FIND(" ",$A$1,(FIND("Mobile:",$A$1)+LEN("Mobile:"))+1)-(FIND("Mobile:",$A$1)+LEN("Mobile:")+1)))

dup.xlsm
	A	B	C	D	E
1	prasad Phone: 9632587410 vishnu Mobile: 8521479630 reddy Mobile: 6541239870	9632587410	9632587410	9632587410
2	prasad Phone: 9632587410 vishnu Mobile: 8521479630 reddy Mobile: 6541239870	9632587410	9632587410	9632587410
3	prasad Phone: 9632587410 vishnu Mobile: 8521479630 reddy Mobile: 6541239870 bobby Phone: 7413698521	9632587410	9632587410	9632587410	9632587410
Sheet5

Cell Formulas
Range	Formula
B1:D1	B1	=MID($A$1,(FIND("Phone:",$A$1)+LEN("Phone:"))+1,(FIND(" ",$A$1,(FIND("Mobile:",$A$1)+LEN("Mobile:"))+1)-(FIND("Mobile:",$A$1)+LEN("Mobile:")+1)))
B3:E3,B2:D2	B2	=MID($A$2,(FIND("Phone:",$A$2)+LEN("Phone:"))+1,(FIND(" ",$A$2,(FIND("Mobile:",$A$2)+LEN("Mobile:"))+1)-(FIND("Mobile:",$A$2)+LEN("Mobile:")+1)))

 

[Prasad K]

You're welcome.

If you wanted a vba solution, I'm wondering why you didn't ask that in post 1 instead of giving us a worksheet formula and asking us to modify that? Would have saved considerable time and effort.

First i have applied formula to extract and it's not done to extract all no
Then I have raised a question what's wrong in formula or change formula

After I went to google search searched for is there any vba code extract mobile no & i have found one VBA function that I have mention above to change as per my required

 

[Prasad K]

You're welcome.

If you wanted a vba solution, I'm wondering why you didn't ask that in post 1 instead of giving us a worksheet formula and asking us to modify that? Would have saved considerable time and effort.

Hi Peter I need a help of with one macro i have

 

[Peter_SSs]

need a help of with one macro i have

Sounds like this is a different request so you should start a new thread about it.

 

[Prasad K]

Sounds like this is a different request so you should start a new thread about it.

Thankyou peter given reply to my request i got answer to my macro