LEN

Returns the number of characters in a text.

=LEN(A2)

Example

A2 = Saroj

Result: 5

TRIM

Removes extra spaces from text.

=TRIM(A2)

Example

” Saroj Pensia ” → Saroj Pensia

UPPER

Converts text into CAPITAL LETTERS.

=UPPER(A2)

Saroj Pensia → SAROJ PENSIA

LOWER

Converts text into lowercase.

=LOWER(A2)

SAROJ PENSIA → saroj pensia

PROPER

Capitalizes the first letter of each word.

=PROPER(A2)

SAROJ PENSIA → Saroj Pensia

Practice

In a customer list:

  • Remove extra spaces
  • Convert names to Proper Case
  • Convert Email IDs to lowercase
PreviousNext