Numbers without Symbols

[#1]

Hi All,

My sales column have values with some special characters. But, I want to take only numeric values from that.

which function is use.

Let me know,

Thanks & Regards,

Sri

[#2]

Hi,

Can you send ur doc with .Doc extension instead of docx

-Jai

[#3]

Dear Jai,

Please find the attachment.

Thanks & Regards,

Sri

[#4]

Sorry chk with this attachment

[#5]

Hi,

   Find the atatchment

-Jai

[#6]

Hi,

This is what i want...

Thanks alot jai

Regards,

Sri

[SunilChauhan]

keepchar(Sales,'0123456789') will give better result and dynamic

[#8]

Ya,,

Thanks alot sunil