FinanceTier 315 minintermediate

Clean Up Imported Vendor Names

Standardise inconsistent vendor names - extra spaces, inconsistent casing - so the same vendor is recognised everywhere.

What you will learn

• Combine TRIM with a case-normalising function to clean text
• Explain why TRIM alone does not fix inconsistent internal spacing or casing
• Recognise two differently-formatted strings as the same vendor once cleaned

Excel skills

TRIM, PROPER/UPPER · Text Cleanup

The task

This imported vendor list has the same handful of vendors typed inconsistently - extra spaces, different casing. In B2, write a formula that produces a clean, consistently-cased version of the vendor name in A2.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free