Hi,

TRIM only works for space created using the spacebar character, although
that doesn't sound like that was your problem, it's still good to know.

Along with TRIM you might also consider CLEAN.

The TRIM function removes all leading and trailing spaces and all but one of
the spaces between words.

--
Thanks,
Shane Devenshire


"BrownsFan" wrote:

I'm attempting to use the Trim function on a column of text data and
it's having no effect. Neither are the left or replace functions.
What are the possible reasons for this?