Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

DEAR SIR YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT. THANKS A LOT -KAVI- On Jul 4, 2:40 pm, Ayush wrote: > Hi , > > You may also refer to below link to extract numbers from the cell > :http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-... > > To attac

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

On Jul 4, 2:40 pm, Ayush wrote: > Hi , > > You may also refer to below link to extract numbers from the cell > :http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-... > > To attach a file you can send an email to excel- > mac...@googlegroups.com by attaching a file. > > Best R

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

DEAR SIR YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT. THANKS A LOT -KAVI- On Jul 4, 12:59 pm, Mahesh parab wrote: > Hi > > find attach sheet as per your requirement,  find info on below link. > > http://www.ozgrid.com/VBA/ExtractNum.htm > > > > On Sun, Jul 4, 2010 at 10:2

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

DEAR SIR YOU HAVE DONE A GREAT FULL HELP FOR ME AND I WILL NEVER FORGET IT. THANKS A LOT -KAVI- On Jul 4, 12:52 pm, ashish koul wrote: > all numeric > > Public Function extractallnumeric(Str) >     Dim i, Numeric1 >     Numeric1 = "" >     For i = 1 To Len(Str) >         If (IsNumeric(Mid(Str,

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

Hi , You may also refer to below link to extract numbers from the cell : http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx To attach a file you can send an email to excel- mac...@googlegroups.com by attaching a file. Best Regards, Ayush Ja

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

Hi find attach sheet as per your requirement, find info on below link. http://www.ozgrid.com/VBA/ExtractNum.htm On Sun, Jul 4, 2010 at 10:25 AM, memonkavi wrote: > DEAR SIR > > PLS ME > > > I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS > WITH ONE FUNCTION OR TWO > > > REGRADS > KAVI

Re: $$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

all numeric Public Function extractallnumeric(Str) Dim i, Numeric1 Numeric1 = "" For i = 1 To Len(Str) If (IsNumeric(Mid(Str, i, 1))) Then Numeric1 = Numeric1 & Mid(Str, i, 1) End If Next i extractallnumeric = Numeric1 End Function all text Publ

$$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

DEAR SIR PLS ME I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS WITH ONE FUNCTION OR TWO REGRADS KAVI NOTE -HOW ATTACH A SAMPLE FILE THIS GROUP -- -- Some important links for excel users: 1. Follow us on T