Optipe Data Tools Suite - Manipulate Text
Manipulate Text application of Optipe Data Tools Suite operates to modify the characters of Excel text strings.
Use 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:
Examples:Video Example. Standardize text.

Video Example. Add prefixes or suffixes to text.

Video Example. Convert numbers entered as text to numbers.