TRIM

Try it

When to use it

What does TRIM remove?

TRIM strips leading and trailing spaces and collapses repeated internal spaces down to a single space. It does not remove other whitespace such as line breaks.

Why do my lookups fail even when the text looks identical?

Stray spaces from imports or copy-paste are a common cause. Wrap both sides in TRIM so an extra trailing space does not break an exact match.

Use cases

Normalize a product label before matching

Strip padding from a code

Used in

operations · retail

Syntax

TRIM(text)