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.