Clean
These functions help you remove spaces, non-printable characters, and other unwanted data.
- 01) Trim Leading and Trailing Blanks From Selected Cells
- 02) Remove ALL Hyperlinks From Active Sheet
- 03) Remove ALL Objects From Active Sheet
- 04) Remove ALL Formatting From Active Sheet
- 05) Change ASCII Characters, TOOL allows you to find and replace ASCII characters
- 06) Clear Zero Length Non Empty Cells
- 07) Remove Defined Names Containing A Reference Error
- 08) Remove Defined Names, Must First Create and Highlight the List You Want Deleted
- 09) Convert ‘Merged Cells’ to ‘Center Across Selection’
- 10) Chop Data Off At First Line Feed Character
- 11) Convert “Trashy Numbers” Strip Out And Keep Just The Numerics (Works On Selection)
- 12) Convert “Spaced Out” Cells To Clear (Works On Selection)
- 13) Convert Several Punctuation Symbols into HTML Strings (Works On Selection)
- 14) Convert “”Non-Date”" To Empty (Works On Selection)
- 15) Remove Annoying ….”Cannot Find XLQUERY.XLA”…. Message from Active Workbook
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc