[bug] Concatenate() formula functionality differs from + operator overload

[Nick_HE]

I’ve been caught by this too. Here are a couple other threads if you want some more details, but you can also just obey Paul’s TL;DR of the situation.

String concatenation failure

The following formula: ":"+"004" returns the string ":4" All zeros are gone. What happened? Meanwhile, I use the workaround: Format(":{1}","004")

Leftpad doesn't work when concatenating with "+" (and number-like strings are converted to numbers)

When you concatenate a string using + instead of concatenate(), LeftPadding is ignored: In fact, this led me to realize that all number-like strings are first forced to numbers before being converted back into strings for concatenation. "Hello" + 007 = “Hello7” (fair enough) "Hello" + "007" = “Hello7” (unexpected) Perhaps this is the intended behaviour, but I certainly find it weird