Cleaning text data

Data Analysis in Google Sheets

James Chapman

Curriculum Manager, DataCamp

Cleaning text data

 

• Who's your favorite DataCamp instructor?

james chapman

James

Jamez chapnam

    James   Chapman

Changing cases - PROPER()

 

• Proper case:
  • Example: This Is Proper Case
  • Used for names and addresses

 

= PROPER("neil armstrong")

Neil Armstrong

Changing cases - LOWER()

 

• Lowercase:
  • Example: this is lowercase

 

= LOWER("Neil Armstrong")

neil armstrong

Changing cases - UPPER()

 

• Uppercase:
  • Example: THIS IS UPPERCASE

 

= UPPER("Neil Armstrong")

NEIL ARMSTRONG

Removing whitespace

 

• Extra whitespace:
  • Leading - space before text
  • Trailing - space after text
  • Repeated - >1 space between characters

 

= TRIM("   Neil   Armstrong   ")

Neil Armstrong

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data

Syntax:

CONCATENATE(string1, [string2, ...])

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Combining text data - email addresses

Example:

• [email protected]

 

Let's practice!

Data Analysis in Google Sheets