s.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Paul Schreiner
> *Sent:* 21 December 2009 23:55
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Extracting Numbers from the Text
>
>
>
> Selva,
>
> I couldn't find a simple
:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Extracting Numbers from the Text
Selva,
I couldn't find a simple way to "find" the numbers
using standard Excel functions, so
I created a function called Get_Number()
It will extract only the numbers from the string.
Hi Selva,
Step 1: Separte the numbers using Text to column using "Space" as
delimiter
Step 2: Select Edit\Go to\ and click special and select constants and
unselct the check box Numbers below the formulas options
Step 3: Delete the selected cells
You have got only the numbers, but in different
Selva,
I couldn't find a simple way to "find" the numbers
using standard Excel functions, so
I created a function called Get_Number()
It will extract only the numbers from the string.
take a look.
Public Function Get_Number(Str)
Dim I, NumStr
NumStr = ""
For I = 1 To Len(Str)
