Manipulate Text in Excel application of Optipe Data Tools Suite operates to modify the characters of Excel text strings.

Data Tools Suite Manipulate Text

Manipulate TextUse this application to:

  • Standardize text from different user files.
  • Normalize data from several information systems or extracted from Internet.
  • Facilitate the processing of numerical data entered as text.

Features:

  • Converts text to uppercase, lowercase, sentence case and title case or proper name.
  • Delete unnecessary spaces.
  • Converts numerical data entered as text to numbers.
  • Remove accents.
  • Allows change a text by other one.
  • Add prefixes or suffixes.
See also:
 
 

BuyNow

Examples:
 
Video Example. Standardize text.

 
Video Example. Add prefixes or suffixes to text.
 

Video Example. Convert numbers entered as text to numbers.