“Text” utilities
Language:
In the Excel menu choose ASAP Utilities » Text to access these 21 utilities:
- Insert before current value... (1 screenshot »)
- Insert after current value... (1 screenshot »)
- Change to UPPERcase (2 screenshots »)
- Change to lowercase (1 screenshot »)
- Start first word with Uppercase (1 screenshot »)
- Make first character Uppercase, the rest lowercase (1 screenshot »)
- Start Each Word With Uppercase
- Convert/recognize dates... (1 screenshot »)
- Delete leading and trailing spaces
- Delete leading, trailing and excessive spaces (3 screenshots »)
- Advanced character remove or replace... (1 screenshot »)
- Replace accented characters (á, ë, ñ etc.)... (1 screenshot »)
- Delete all text characters (a-z) in selected cells (1 screenshot »)
- Delete all numbers in selection (1 screenshot »)
- Remove ending carriage return (alt+enter character)
- Delete number of leading characters... (2 screenshots »)
- Delete number of ending characters...
- Delete all after a given number of characters...
- Make last character superscript (1 screenshot »)
- Make last character subscript (1 screenshot »)
- Reverse text in selected cells (1 screenshot »)
Submenu screenshot
« Return to the list of tools.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 