Function required removing special characters

[Arun C M]

Dear All,Is there any function/formula in Excel sheet that can remove special characters in data?Question BBD/B CNABC>C ANUN>A/A CNBBD*A ABNAnswersBBDB CNABCC ANUNAA CNBBDA ABNPlease help me…….Arun C M</PRE>

 

[ColinKJ]

It is data you want to remove it from and now formual isn't. ?

Which special charaters do you want to remove?

ColinKJ

 

[Krishnakumar]

Hi,

Hit CTRL + H

find what: /
replace with:

click replace all

find what: >
replace with:

click replace all

find what: ~*
replace with:

click replace all

Note: leave the 'Replace with:' column empty.

HTH