Printing labels - extra space for unused field

[Noreenmachine]

Hi there. I have an avery label layout which is working well, except for one thing.

I have a combined "field" in the layout which is:

Salutation & " " & First Name & " " & Last Name & " " & Professional Designation

However, when the Salutation is blank, it leaves a space before the First Name. How do I get rid of it?

Thanks!

[comment]

Try:

Trim ( Salutation & " " & First Name & " " & Last Name & " " & Professional Designation )