Cell Cleaner for Microsoft Excel 126.96.36.199
The character trimming functions
Cell Cleaner for Microsoft Excel features powerful functions for text scanning, that can automatically remove unnecessary or unaesthetic characters from the text lines contained within cells. For example, it can trim leading or trailing spaces, meaning remove excess spaces before and after cell values. Moreover, it can remove excess spaces between the words, that appear due to misspelling or incorrect copy-pasting.
Additionally, it can delete non-breaking spaces from cells or non-printing characters. Line breaks that you place in certain cells, for instance, are non-printable, thus unnecessary within the text line. You may remove all numeric or text characters from a selected cell, as well as delete symbols, punctuation marks or other characters that the printer might not recognize.
Simple to use lettercase changer
The ‘Change Case’ function allows you to modify the text contained within the selected cells to all upper/lower case, or capitalize only the first letter of each word. You may thus transform the text in a cell to a song/novel title format. Additionally, you may only capitalize the first letter from each cell. The cell range is defined in the field at the top of Cell Cleaner for Microsoft Excel’s menu. Additionally, you may convert numbers that are stored as text to numbers, or find and replace all similar characters with a custom symbol.
Page arrangement within seconds
Cell Cleaner for Microsoft Excel is a reliable tool that can save you much time, in case you need to transform the text in a spreadsheet into the proper format. Often times it happens that the Excel sheets contain spelling mistakes, extra spaces or unnecessary characters. You may easily clean these characters and convert the text to the desired format.
Reviewed by Elizabeta Virlan, last updated on October 4th, 2014
In a hurry? Add it to your Download Basket!
- The add-in is left installed when Ablebits Ultimate Suite is removed in Excel 2003.
Application descriptionWith this add-in for Excel you will be able to easily clean data imported from any external source thus getting it to ...