# Using Text Tools

To display the Text Tools dialog box, choose Text Tools from Utilities group on the Home tab.

The Text Tools utility always works with the current range selection. The Text Tools dialog box is a "stay on top" dialog box. This means that you can easily select different cells to work with, and continue working in Excel while the dialog box remains on screen. The cell selection can consist of a discrete range, entire rows or columns, a multiple selection, or even the entire worksheet.

When you are finished using Text Tools, click Close.

Changing the case of text

1. In the Text Tools dialog box, select the Change case operation.
2. Select the appropriate Change to option to convert the selected text.
3. Click Apply to modify the selected cells.

Adding text

1. Select the cells that you want to modify.
2. In the Text Tools dialog box, select the Add text operation.
3. Enter the text you want to add in the Text to add box.
4. In the Character position drop-down, select the option that corresponds to the position where you want the text to be added.
5. If you want to limit the operations to selected cell that contain text, select Skip non-text cells. If this option is not checked, cells that contain values will also be modified.
6. Click Apply to modify the selected cells.

Removing text by position

1. Select the cells that you want to modify.
2. In the Text Tools dialog box, select the Remove by position option.
3. In the Characters to remove drop-down, choose the number of characters to be deleted.
4. In the Character position drop-down, choose the position from which you want the characters removed.
5. If you want to limit the operation to selected cells that contain text, select Skip non-text cells. If this option is not checked, cells that contain values will also be modified.
6. Click Apply to modify the selected cells.

Removing spaces

1. Select the cells that you want to modify.
2. In the Text Tools dialog box, select the Remove spaces option.
3. In the Remove drop-down, select the option that corresponds to the spaces that you want to remove.
4. Click Apply to modify the selected cells.

Note: Selecting All Excess Spaces is equivalent to applying Excel's TRIM function to the cells.

Deleting characters by type

1. Select the cells that you want to modify
2. In the Text Tools dialog box, select the Delete characters option.
3. In the Remove all drop-down, select the option that corresponds to the type of characters that you want to remove.
4. Click Apply to modify the selected cells.

Note: Selecting Non-printing characters is equivalent to applying Excel's CLEAN function to the cells.

More

- Tips