8 tools to manage text data in Excel

Text Toolkit is a set of add-ins for Microsoft Excel, it includes 8 utilities, that perform more than 25 operations. This set is a time-saver if you need to fix your textual data, e.g. change case, trim spaces, replace characters, extract substrings, count characters, split cells, add text, remove line breaks, etc.

There are six major verbs, which characterize the Toolkit the best: change, remove, extract, add, split, count. You will be able to change case and convert text. You will enjoy removing spaces and characters. You will easily extract the needed text or numbers, add any text to any place in any range, split text according to certain symbols and count characters or words.

Select the cells, columns or rows where you want to remove excess spaces. Start the Trim Spaces utility by clicking on its icon. Choose one or more options: trim leading/trailing spaces, remove excess spaces between words, delete non-breaking spaces. Click the Trim button.

More information and screenshots can be found here.

Select your table and run the Change Case tool. Choose the text case you need: upper, lower, proper or sentence case. Click on Change Case.

For a more detailed description click here.

Try the Extract Text utility. It can pull any number of first or last characters from a cell. Also, you can extract a substring starting from the specified position and get all symbols before or after certain text. Additionally, you can get all numbers from the selected cells.

More information and screenshots find here.

Yes, there is a special tool for your task, the Count Characters utility. It allows to count all characters in the chosen cells,count only certain characters, and see the number of words. Besides, you can insert the result as a formula.

See how it works here.

Have a look at the Split Text utility. It splits cells by character, mask, or strings. Choose how to split your cells: to columns or to rows.

For a detailed description click here.

Add Text utility will do it. Enter your text and select its position: at the beginning of the selected cells, at the end, before/after certain text, or after a certain number of characters from the beginning/end. You can process only text cells and skip empty cells.

See how it works here.

With the Remove Characters tool you can easily delete all non-printing characters as well as specified text strings, numbers, symbols and punctuation marks. Also, you can remove as many first/last chars as you want, and clear all characters before of after certain text.

For a detailed description click here.

The Convert Text button will do it in a flash. Besides, it will help to replace characters and convert line break to semicolon, comma, or space.

Find more details here.

Yes, Extract Text and Count Characters/Words utilities allow you to insert your result as a formula.