Excel

Fix one messy range

A column of names and amounts arrived with broken dates, extra spaces, and a total that does not add up.

1. 01

   Open the workbook and select the messy range.

2. 02

   Open Excelsior from the Home tab and sign in.

3. 03

   Ask it to fix the dates, trim the names, and correct the total in that range.

4. 04

   Read what changed before you move on.

You leave with a clean block.