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
Page 1 / 1
found the answer:
CONCATENATE(Town," ", Address," ",{No / unit})
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.