Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread Shiva Prasad
hi ashsih koul, it is working very thanks , regards, shivaprasad. On Fri, Oct 19, 2012 at 9:16 PM, ashish koul wrote: > check the attachment see if it helps > > > On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad > wrote: > >> hi ashish koul, >> >> please find the attachment of example. >> >

Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread ashish koul
check the attachment see if it helps On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad wrote: > hi ashish koul, > > please find the attachment of example. > > i mentioned formula also but showing 0 value. > please provide the macro. > > > regards, > shivaprasad. > > On Fri, Oct 19, 2012 at 9:02 PM,

Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread Shiva Prasad
hi ashish koul, please find the attachment of example. i mentioned formula also but showing 0 value. please provide the macro. regards, shivaprasad. On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote: > can u share any excel file with input and output u like to have > > > On Fri, Oct 19, 20

Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread ashish koul
can u share any excel file with input and output u like to have On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad wrote: > hi ashish koul, > > please provide the example attachment. > > > regards, > shivaprasad. > > > On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > >> try this udf >> >> Funct

Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread Shiva Prasad
hi ashish koul, please provide the example attachment. regards, shivaprasad. On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > try this udf > > Function numeric_value(x As String) > Dim a As String > a = "" > For i = 1 To Len(x) > If IsNumeric(Mid(x, i, 1)) Then > a = a & Mid(x, i, 1) >

Re: $$Excel-Macros$$ request to separate the no

2012-10-19 Thread ashish koul
try this udf Function numeric_value(x As String) Dim a As String a = "" For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then a = a & Mid(x, i, 1) End If Next i numeric_value = a End Function On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad wrote: > hi experts, > > how to separate the number, > i m

$$Excel-Macros$$ request to separate the no

2012-10-19 Thread Shiva Prasad
hi experts, how to separate the number, i mentioned in excel cell please help me *example asdfhfgh9825101236sdfge, 9855255689dffhjrr * i want only number, can any one provide the macro. regards, shivaprasad. -- Regards, Shivaprasad K. +91-9866351016 -- Join official facebook page of