-4

I am trying to do what this guy did in this question - Get the errors using SUM(IF(ISERROR) But I don't need to format it after that - I need to remove those special characters.

I need to remove special characters from a column that has 266 records. I use Excel 2003 so the SUBSTITUTE can't be used for Nesting more than 8 levels.

  • Are you trying to remove the same set of special characters that were in the other question, or a different list of special characters? – Jason Aller Feb 21 '15 at 3:10
  • 2
    Why didn't you follow up on the question you already had? – Raystafarian Feb 21 '15 at 12:38
1

If it's the same list of special characters, you don't need to nest the formulas too many times.

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"`",""),"'",""),"""",""),"/",""),"\",""),"^","")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.