Thanks for the explanations.
What I had put forth was just an example, sorry for the confusion it caused. In reality I wanted to do this
concatenate(A2," - ", b2, " - ", c2) where a2, b2 and c2 are strings. If c2 is empty then the resultant string will have an hyphen at the end, which I...