Removing special characters


I am importing from excel and ending up with extra characters in the cell. For example, instead of the cell displaying:

Spanish, Portugues

I am instead seeing:


Is there a formula that would remove the [ ] " from the cell?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!