Hello Forum
Hope you can help me on this one.

I have to copy and paste about 200 contacts and whenever I do this the address line places the text into the address fields with a space which I have to then delete.
E.G

123 the Avenue
is pasted as
_123 the Avenue

_ = space

Is there a function that will automatically delete the space?

Hope you understand.

Thanks

Martin

Sure. Enter all your data then run a replace (From the menu, Records / Replace Field Contents) on the field using the Trim() function.

Or, change the address field to an auto enter calc that uses the Trim() function: be sure to uncheck "Do not replace existing value...".

You'll love it.