AdvancedData Cleaning12 min35 points

Reconcile a list with hidden spaces

The situation

Half of Harbor Supply's customer list is failing to match the supplier's file even though the names look identical on screen. The exported names carry trailing spaces, which Excel treats as different text and no amount of staring at the screen will reveal.

Reconcile a list with hidden spaces — question sheet. Use the arrow keys to move between cells, Enter or F2 to edit, Escape to cancel, Control D to fill down from the cell above, and Control C and Control V to copy and paste.
Row number	A	B	C
1	Exported name	Result	Master list
2	Dockside Hardware		Dockside Hardware
3	Fenwick Building		Fenwick Building
4	Alder & Vance		Alder & Vance
5	Riverbend Trade		Riverbend Trade
6	Kemper Outfitters		Kemper Outfitters
7	Halloway Supply		Halloway Supply
8