Get startedGet started for free

Equal length

The IT department sends you an email. Some values in the Customer State column could have unwanted characters due to a processing error with the customer information database. This could be an issue! You must use some text category functions to clean the data and continue the data preparation process.

If you lost progress, close any open reports and load 2_1_equal_length.xlsx from the Workbooks folder. If a message appears saying "Security Warning - External Data Connections have been disabled", click on Enable Content and continue.

This exercise is part of the course

Data Preparation in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise