October 31, 200619 yr 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!
November 1, 200619 yr Try: Trim ( Salutation & " " & First Name & " " & Last Name & " " & Professional Designation )
Create an account or sign in to comment