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.
> For I = 1 To Len(Str)
> > If (IsNumeric(Mid(Str, I, 1))) Then
> > NumStr = NumStr & Mid(Str, I, 1)
> > End If
> > Next I
> > Get_Number = NumStr
> > End Function
>
> > paul
>
> > --
>
21, 2009 11:56:32 AM
Subject: $$Excel-Macros$$ Extracting Numbers from the Text
Dear All Excel Gurus,
This is my first mail to this group. I have read many mails from this group
which is of great useful to me.
Currently I am finding a problem in extracting the employee no from the
scrambled da
Dear All Excel Gurus,
This is my first mail to this group. I have read many mails from this group
which is of great useful to me.
Currently I am finding a problem in extracting the employee no from the
scrambled data. (Attached reference file)
What I need is I want to extract out only the
