Explanation

Data should use consistent formats.

Example

Incorrect:

City
Sirsa
sirsa
SIRSA
Sirsa

These may represent the same city but are written differently.

Use:

=PROPER(TRIM(A2))

Result:

Clean City
Sirsa
Sirsa
Sirsa
Sirsa

Other Examples

Category:

accessories → Accessories

Customer:

amit kumar → Amit Kumar

Practice

Standardize:

• Customer names
• Cities
• Products
• Categories