Excel Text Operations

Spreadspeed offers a variety of tools that make it easy to fix commmon problems and perform special operations on text.

Trim Text

Common trim operations can be performed directly via the Spreadspeed ribbon:

For more complex needs, there is also the Advanced Trim Tool, which allows you to select a range of text and trim more than just white space. Advanced Trim offers the following set of options:

Advanced Trim Tool Screenshot

Advanced Trim Tool

Add Prefix / Suffix to Text

The Add Prefix / Suffix tool allows you to add prefixes and/or suffixes to a selected range of cells. The append / prepend options are as follows:

Add Prefix / Suffix Screenshot

Append / Prepend Text

Change Case

The following change case operations operate directly on the selected cells via the Spreadspeed ribbon, or by using the Change Case dialog to select the range and case options:

Change Case Screenshot

Change Case Tool

Name Case

The Name Case tool will check and correct the capitalization of a list of names. It's perfect for correcting email lists and other lists of names. It acts much like the Title Case tool, but it also has a number of special rules for common mixed-case name spellings:

Name Case Screenshot

Other Text Utilities