blank spaces with import

[cebrown]

Hello,

I have a user whose database is 4.1 and she imported from an Excel doc. Unfortunately, extra characters, actually blank spaces, came in with most of the fields. She is trying to create labels and even though she is using merge fields, the blank spaces are not allowing the merge fields to slide up or over. Short of going into every field that has the blank spaces at the end of the text, is there a way to clean up these spaces globally? The excel sheet doesn't show extra spaces so I am guessing that the original document prior to excel did not cleanly save as an excel doc. Unfortunately, the user does not have access to the original doc nor does she know what application created it. Thanks for your help!

[EddyB]

You could create new fields for the labels to use and strip the spaces out that way.

For example if you have a field called NAME

Create another field called NS_NAME make this a calculation field and use TRIM(NAME) this will remove the spaces.

You could then use the field NS_NAME for the labels

Ed.

[cebrown]

This did the trick! Thank You so much!