Expand the Remove unwanted characters section by clicking on the arrows next to the second tab.
Select the range with the cells that contain values you want to remove.
Choose the option that suits your task. You can select one of these five options:
Remove non-printing characters – delete all non-printing characters like line breaks, the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) and additional nonprinting characters (values 127, 129, 141, 143, 144, and 157);
Remove numeric characters – delete all digits from the selected cells
Remove text characters – delete all letters from your cells;
Remove symbols and punctuation marks - this option removes all punctuation marks in the selected range as well as the following symbols: mathematical, geometric, technical and currency symbols, letterlike symbols such as ?, ?, and ™.
Remove custom characters – If you have several characters that you need to delete from your range and you don't want to repeat this routine operation several times, just enter each character you need to delete into Remove custom characters field.
