New!: Kutools For Excel

A new workbook opened. Elias’s jaw dropped. Sheet 1 contained Branch 1. Sheet 2 contained Branch 2. But wait—there was a Master Sheet. Kutools had not only combined the workbooks but had aggregated the data into a single summary sheet at the front.

He scrolled through the data. He noticed that some cells had strange trailing spaces—invisible characters that messed up lookups. He usually handled this with the =TRIM() function. He looked at the Kutools menu. He clicked it. It offered to remove leading, trailing, and even excess spaces between words. He checked all three. Gone. kutools for excel