#Excel #Tips | How To Remove Special Characters | 2020 | Easy Steps to Remove Unwanted Characters

#Excel #Tips | How To Remove Special Characters | 2020 | Easy Steps to Remove Unwanted Characters
Do you know how to remove special #characters from a excel columns without #advance excel knowledge? Cleaning data is very important and basic for data analysis. This video will help you to understand on how to remove special characters from excel using a ADDON

In this video I be showing you on #howto #remove #characters, #text, #numbers from Microsoft excel / #msexcel files using an easy plugin.

I am new to YouTube & require your support to grow.
Please like my videos & subscribe if my video is helpful for you. 👍👍👍

Subscribe & Support

[datascience]

I have a similar problem. Basically in a dataset I have a column with the age class, for instance 5-9, 10-15, 20-25 ecc. I wanna set a function such as I make sure that there are no words or special characters in the column and extract where there happens. The “-“ should be allowed in the middle of the two numbers though. How can I do that?

[Pokemonmaster]

It does not work in my Excel 2016. Simply returns "Sorry, The set operation failed because the supplied data object will overwrite or shift data." I will appreciate any help.