Forum Discussion
Hide a hyphen used in Concatenate.
I am using a hyphen (-) in the concatenate function to link cells A1 & A2 into Cell A3,
Eg, =CONCATENATE(A1," - ",A2).
When the cells A1 &A2 have no data in them, how can I prevent cell A3 from d...
Simon,
you could use TEXTJOIN():
=TEXTJOIN("-",TRUE,A1:A2)
That's right. TextJoin is a great alternative, but it is only available in Excel 2016, not earlier versions.