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," ")

Join the conversation!

This site uses Akismet to reduce spam. Learn how your comment data is processed.