View Single Post
 
Old 02-26-2018, 08:40 AM
bulrush bulrush is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Feb 2018
Posts: 6
bulrush is on a distinguished road
Default

- The Cellview addin is what I already have, and normally works to show hidden characters, but that does not help me delete these characters in one step.
- It will take me a bit to delete thousands of lines to show only the weird lines.
- Doing =code(c35583) gives me 67, and on another cell gives me 70.
- Is there an easy way to specify a range or rows to delete without taking 5 minutes to select them? Or delete all rows not shown via a filter? I'm trying to smallify and sanitize this spreadsheet a bit for privacy.
Reply With Quote