Extracting numbers from text
 

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell include reply
cell include formula
__ _________________________ ____ ___ ________
_____
A1 MR FRANK (25687) ----- B1
25687 ?
A2 MR FRANK 256875787 ----- B2
256875787 ?
A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875
?
A4 MR FRANK 2560 IN U.S ----- B4 2560
?
A5 81602MR FRANK ----- B5
81602 ?
would you please write for me the correct formula in cells B1 to B5 to
achieve the reply just like above.

Extracting numbers from text
 

Hi,

Try this link below. It shows how to extract numbers from text. Detailed
explanation on how to use it is also given.

http://www.ozgrid.com/VBA/ExtractNum.htm

HTH,
--
Tausif Mohammed


"SIAMAK" wrote:

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell include reply
cell include formula
__ _________________________ ____ ___ ________
_____
A1 MR FRANK (25687) ----- B1
25687 ?
A2 MR FRANK 256875787 ----- B2
256875787 ?
A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875
?
A4 MR FRANK 2560 IN U.S ----- B4 2560
?
A5 81602MR FRANK ----- B5
81602 ?
would you please write for me the correct formula in cells B1 to B5 to
achieve the reply just like above.

Extracting numbers from text
 

On Tue, 22 Jul 2008 21:01:02 -0700, SIAMAK
wrote:

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell include reply
cell include formula
__ _________________________ ____ ___ ________
_____
A1 MR FRANK (25687) ----- B1
25687 ?
A2 MR FRANK 256875787 ----- B2
256875787 ?
A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875
?
A4 MR FRANK 2560 IN U.S ----- B4 2560
?
A5 81602MR FRANK ----- B5
81602 ?
would you please write for me the correct formula in cells B1 to B5 to
achieve the reply just like above.

You have posted this clarification before, and I responded to it (as did
others).
--ron

Extracting numbers from text
 

"Ron Rosenfeld" wrote:

On Tue, 22 Jul 2008 21:01:02 -0700, SIAMAK
wrote:

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell include reply
cell include formula
__ _________________________ ____ ___ ________
_____
A1 MR FRANK (25687) ----- B1
25687 ?
A2 MR FRANK 256875787 ----- B2
256875787 ?
A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875
?
A4 MR FRANK 2560 IN U.S ----- B4 2560
?
A5 81602MR FRANK ----- B5
81602 ?
would you please write for me the correct formula in cells B1 to B5 to
achieve the reply just like above.

You have posted this clarification before, and I responded to it (as did
others).
--ron
thanks for your help, ron . it was good but it could not show points and negative.
but the linke that is recommended by tausif was more complete.

Extracting numbers from text
 

Hi,
thank you for your reply ; Tausif. the link you recommended was useful for
me.

"siamak"

"Tausif" wrote:

Hi,

Try this link below. It shows how to extract numbers from text. Detailed
explanation on how to use it is also given.

http://www.ozgrid.com/VBA/ExtractNum.htm

HTH,
--
Tausif Mohammed

Extracting numbers from text
 

On Fri, 25 Jul 2008 21:08:00 -0700, SIAMAK
wrote:



"Ron Rosenfeld" wrote:

On Tue, 22 Jul 2008 21:01:02 -0700, SIAMAK
wrote:

with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
complete. let me ask it clearly as below:
cell include reply
cell include formula
__ _________________________ ____ ___ ________
_____
A1 MR FRANK (25687) ----- B1
25687 ?
A2 MR FRANK 256875787 ----- B2
256875787 ?
A3 MR FRANK (256875) AT2008/2/6 ----- B3 256875
?
A4 MR FRANK 2560 IN U.S ----- B4 2560
?
A5 81602MR FRANK ----- B5
81602 ?
would you please write for me the correct formula in cells B1 to B5 to
achieve the reply just like above.

You have posted this clarification before, and I responded to it (as did
others).
--ron
thanks for your help, ron . it was good but it could not show points and negative.
but the linke that is recommended by tausif was more complete.

No wonder. You gave no reason, in your requests or examples, to show points or
negatives. That would have been easily remedied merely by making the
appropriate changes in "pattern". But I'm glad you found a solution that works
for you.


--ron