Scenario:
CONCATENATE(Town, "-", Address, "-", {No / unit})
displays for example Town-Address-100
Question:: I would like the display to appear as Towm Address 100. How do I enter a blank space between the field items rather than a - ?
tia
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.