Tuesday, 10 June 2014

Text Utilities Overview

There are 5 main commands in Text Utilities:

  • Text Case: Change Text Case to Proper case, UPPER case and lower case
  • Prefix Suffix: Add Prefix and Suffix to the text in cells
  • Clean Text: Clean unwanted characters in the text
  • Strip Text: Strip text is a quick way to delete unwanted string of characters in the text based on certain criteria. It is useful in extracting URLs' parts or clean up URLs.
  • Clear format: Clear all Excel cells formats, i.e. cell color, font, etc.

Output Options

The Options button is for more output options. More on Output Options of Text Utilities Commands.