These functions are useful for cleaning and standardizing text data.

TRIM

Removes unnecessary spaces from text.

Syntax

=TRIM(text)

Example:

”  Amit   Kumar  “

Formula:

=TRIM(A2)

Result:

Amit Kumar

UPPER

Converts text to uppercase.

=UPPER(A2)

Example:

sircl tech

Result:

SIRCL TECH

LOWER

Converts text to lowercase.

=LOWER(A2)

Example:

SAROJ@GMAIL.COM

Result:

saroj@gmail.com

PROPER

Capitalizes the first letter of each word.

=PROPER(A2)

Example:

saroj pensia

Result:

Saroj Pensia

Practice

Clean this customer list:

Original Name

amit kumar

NEHA SHARMA

rahul singh

PRIYA GUPTA

Use TRIM, UPPER, LOWER, and PROPER.

PreviousNext