Removing Unnecessary Characters from Excel Cell-CodePudding

Home > Back-end > Removing Unnecessary Characters from Excel Cell

Removing Unnecessary Characters from Excel Cell

Time：01-28

Below is a listing of some cells with unnecessary text. The text to remove would be /%%, -, and empty spaces.

CodePudding user response：

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1;"/";"");"-";"");" ";"");"%";"");";";"")

change semikolon to comma

This will remove all the charakters at once.

Your first formula is not working for me.