Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Excel: Find and replace across all worksheets

I needed to remove carriage returns, line feeds and tab characters from an Excel spreadsheet that was copied straight out of Microsoft Access, and have written the script below1, which has the other options for replacing if you need to change it:

  1. please run this on a copy of the spreadsheet before running it, just in case the worst happens

Leave a Reply

Your email address will not be published. Required fields are marked *

CJayMead's SQL Server, Endeca, MS Office Help © 2018