Many times we need to remove specific character from text
string in excel worksheet. We usually perform this activity as a data cleansing
process before generating reports/dashboard in reporting tools like Microsoft Excel, Tibco Spotfire, Tableau, Qlikview and so on. Removing specific character from
excel cells manually is a quiet time consuming task. Also, there might be a
possibility to forget to miss few characters in data which is not adequate.
We can automate this task by creating a user defined
function which will be used to delete specific character from the input text. We
can customize a function in such a way that it will remove specific character
or special character from input text.
