Extracting numbers from text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SIAMAK - 23 Jul 2008 05:01 GMT

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.

Reply to this Message

Tausif - 23 Jul 2008 06:18 GMT

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,

Signature

Tausif Mohammed

> with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
> complete. let me ask it clearly as below:
[quoted text clipped - 14 lines]
> would you please write for me the correct formula in cells B1 to B5 to
> achieve the reply just like above.

Reply to this Message

SIAMAK - 26 Jul 2008 05:13 GMT

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

"siamak"

> Hi,
>
[quoted text clipped - 4 lines]
>
> HTH,

Reply to this Message

Ron Rosenfeld - 23 Jul 2008 13:19 GMT

>with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
>complete. let me ask it clearly as below:
[quoted text clipped - 14 lines]
>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

Reply to this Message

SIAMAK - 26 Jul 2008 05:08 GMT

> >with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
> >complete. let me ask it clearly as below:
[quoted text clipped - 19 lines]
> --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.

Reply to this Message

Ron Rosenfeld - 26 Jul 2008 12:56 GMT

>> >with thanks from Bob,Rick,Ron and suleman ; I think my last question was not
>> >complete. let me ask it clearly as below:
[quoted text clipped - 20 lines]
>> 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

Reply to this Message