Dear Ashish Sir,
Thanks a ton for your help. Your macro is working perfect.
Thanks a lot sir.
Regards
Ashu Kenith.
On Tue, Dec 23, 2014 at 11:26 AM, Ashish Kumar
wrote:
> Hi Ashu,
>
> Check this
>
> Resolved by VBA. HIT the button and select your data and press OK.
>
>
> Regards
> Ashish
>
>
Dear Ashish Bhalara Sir,
Thanks for your help, but this udf is not working according to my
requirement.
Regards
Ashu Kenith.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/
Hi Ashu,
Check this
Resolved by VBA. HIT the button and select your data and press OK.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM R
Use below code of UDF.
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars =
"\/:*?""{}[](),!`~\:;'._-=+&^%$<>|ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
For i = 1 To Len(sSpecialChars)
sInput = Replace$(sInp
vba.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 11:13 AM, Ashish Kumar
wrote:
> Hi Ashu,
>
> You want resolution by VBA or formula.
>
> Reply.
>
> Regards
> Ashish
>
> On 23 December 2014 at 11:10, Ashu k wrote:
>
>> Dear Seniors,
>>
>> I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in
Hi Ashu,
You want resolution by VBA or formula.
Reply.
Regards
Ashish
On 23 December 2014 at 11:10, Ashu k wrote:
> Dear Seniors,
>
> I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want
> extract only Numbers and delete rest of string. It's possible.
>
>
> Please help.
>
>
Dear Seniors,
I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want
extract only Numbers and delete rest of string. It's possible.
Please help.
Thanks
Ashu Kenith.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join offici
