Ravi Sir's Cards › Excel
Cleaning: leading zeros, hidden spaces, text dates
Revision card: Cleaning: leading zeros, hidden spaces, text dates. Example data table with Code 007 typed as 7: 007; TRIM leaves a space after Salman in B2: Salman; Is C3 a real date?: FALSE.
Read card text
What this card says
Cleaning: leading zeros, hidden spaces, text dates
Example
data table with Code 007 typed as 7: 007; TRIM leaves a space after Salman in B2: Salman; Is C3 a real date?: FALSE
Learn this in the lesson: 5. Data Cleaning A–Z