Find cells containing excessive spaces used instead of line breaks by marking such cells with a specific fill color.
Find Excessive Spaces tool finds cells that contain an excessive number of spaces, usually used to break text to another line, and marks them with a specific fill color. You can then replace these spaces with line breaks manually or by using Remove Excessive Spaces command.
Preparing to find cells that need to be processed with Remove Excessive Spaces tool
- Specify a fill color that must be applied to cells containing an excessive number of spaces.
- Process the current worksheet or selected cells only.
Tools for document formatting and preparation before/after translation
- Remove Excessive Spaces (Excel) – replace excessive spaces used to wrap text to another line with line breaks