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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
