TransTools is a free (for personal use) suite of tools to help clean up with the text in Word, Excel, Visio and AutoCAD files. It's aimed at translators but could prove useful for many others.
The program installed easily, with no hassles. It seems to work just about anywhere - there are separate Office add-ins for 2003 and earlier, 2007 and later, 32 or 64-bit - and correctly added itself to our Word and Excel 2013 ribbons.
The Word add-in features a Document Cleaner which tidies up documents produced by OCR or PDF conversion software. This can restore more consistent formatting (fonts, font sizes, spaces, styles), remove unwanted frames, correct problems with tables, reset indentation, remove text highlighting, shading and more. Just choose the actions you need, and click to carry them out.
There are also many smaller corrective options. You're able to remove excessive spaces, and replace them in various ways (with spaces, tabs, a new line or paragraph). A "Remove Highlight" tool can strip out highlights in a particular colour. And the Non-breaking Space Checker does what its name suggests, scanning your document to ensure any non-breaking spaces are used correctly.
The Excel add-in has several more spreadsheet-specific tools. The Cell Resize Wizard resizes cells as required to make text fully visible, for instance, while the Translation > Extract... tool extracts all unique text and displays it in a separate workbook. But there are also simpler formatting tools, including options to remove highlighting or excessive spacing.
We didn't try them, but it seems that TransTools for Visio and AutoCAD work like a stripped down version of the Excel add-in, extracting text from the document, then allowing you to merge it back - with any translations or modifications - later.
•Added a new tool – What Is This Text Symbol? (TransTools for Word). This command analyses text you select in Microsoft Word and identifies every text symbol it contains.
•Updated Document Cleaner / Autoformat tool (TransTools for Word): the first option was renamed to “Highlight paragraphs formatted using several different fonts, font sizes or font colors”. In this version, in addition to highlighting paragraphs formatted with different fonts or font sizes, this option also highlights paragraphs formatted with different font colors.
•Added two new Quick Actions commands under Document Cleaner / Other Tools (TransTools for Word):
1.Textboxes - Move text out of all textboxes (entire document) – this command converts all floating textboxes to text, placing the text at the place to which each textbox was anchored and deleting original textboxes.
2.Textboxes - Convert all textboxes to frames – this command converts all floating textboxes to Word frames.