Want to create a Full Name value from name elements. Wrote this simple formula:
CONCATENATE(
{First Name}, " ",
{Middle Name}, " ",
{Last Name}
)
If there is a value in all three fields, it works fine, returning a result like (say) “William Jefferson Clinton”.
But it also works fine if there isn’t a Middle Name value – and that is contrary to what I expect. If Middle Name is left empty, it will return “Bill_Clinton”: I’m using an underscore there to represent a single space. What I expect is for it to return “Bill__Clinton”, with two spaces in there. Why doesn’t it? What am I missing?
