How to remove special characters in a excel

**Latha Mani** · 01-10-2014, 09:57 AM

Hi

I want to remove all the special characters i need only texts and numbers.

Thanks.

**Latha Mani** · 01-10-2014, 10:11 AM

Hello

I need to remove all the characters in a sheet except alphabets and numbers.

Please do the needful..

**Jakobshavn** · 01-10-2014, 10:17 AM

Select the cells you want to purify and run this small macro:

Please Login or Register  to view this content.

**Latha Mani** · 01-10-2014, 10:23 AM

Hi

but it also removes spaces between the words

**Latha Mani** · 01-10-2014, 10:26 AM

i want to remove the special characters alone..i need the spaces between the words

Thanks

**Jakobshavn** · 01-10-2014, 11:06 AM

Here is a version that will not remove spaces:

Please Login or Register  to view this content.

**Latha Mani** · 01-10-2014, 11:33 AM

Thank you...

Re: How to remove special characters in a excel