Manipulate Text in Excel application of Optipe Data Tools Suite operates to modify the characters of Excel text strings.
Use this application to:
- Clean 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.
