CONCATENATE - blank space between

Michael_Lever · ‎Dec 11, 2022

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

Michael_Lever · ‎Dec 11, 2022

found the answer:

CONCATENATE(Town," ", Address," ",{No / unit})