“Text” utilities
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語In the Excel menu choose: ASAP Utilities » Text
- Insert before and/or after each cell in your selection...
- Change to UPPERcase
- Change to lowercase
- Start first word with Uppercase
- Make first character Uppercase, the rest lowercase
- Start Each Word With Uppercase
- Change Case (with options)...
- Spell/write out numbers or amounts (EN, DE, FR, NL)...
- Convert/recognize dates...
- Delete leading and trailing spaces
- Delete leading, trailing and excessive spaces
- Clean data and formatting...
- Find and/or replace in all sheets...
- Advanced character remove or replace...
- Replace accented characters (á, ë, ñ etc.)...
- Delete all text characters (a-z) in selected cells
- Delete all numbers in selection
- Remove ending carriage return (Alt+Enter)
- Delete number of leading characters...
- Delete number of ending characters...
- Delete all after a given number of characters...
- Subscript the numbers in Chemical Formulas
- Make last character superscript
- Make last character subscript
- Reverse text in selected cells
- Sort values inside each cell in selection...
Submenu screenshot
Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu
Excel 2003, 2002/XP or 2000 with ASAP Utilities in its menu
« Return to the list of tools.
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
