Trim(Text) won't trim

[rlake]

I'm a novice with Filemaker 5.5 on Windows XP Pro. I need to "TRIM" several text fields. I have created duplicate calculation (results in text) fields. The "TRIM" is not trimming. All I've done is make a nice duplicate of the original fields with the same problem, extra spaces to the left. I already have the field formatted to left justify. Most of the records were keyed in correctly but too many were keyed in with 1 or 2 spaces to the left of the field. Thanks in advance. ;)

[Lee Smith]

Hi rlake, and Welcome to the Forum.

I'm confused by your description of what is happening. The Trim Function is pretty streight forward. Maybe you can give us a couple of example fields, and the calculation you are trying.

Lee