links for 2008-12-01

Excel's CONCATENATE() function takes multiple arguments, but each cell must be listed separately. In addition, if you want to delimit the concatenation by, say, inserting a space between cell texts, you have to add a separate delimiter for each cell, e.g.:

= CONCATENATE(A1 & " " & B1 & " " & C1)

The MultiCat() function allows you to use a more compact syntax:

= MultiCat(A1:C1," ")