LEN, TRIM, CLEAN

Working with messy text? These formulas help:

LEN Example

=LEN(A2)

Counts characters including spaces.

TRIM Example

=TRIM(A2)

Removes extra spaces (but keeps single spaces).

CLEAN Example

=CLEAN(A2)

Removes non-printable characters.

Tip

Combine them:

=TRIM(CLEAN(A2))

Cleans text perfectly.

Common Issue: Imported data often contains hidden characters → use CLEAN + TRIM to fix.