• McGimpsey & Associates : Excel : UDFs : Multicat
    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," ")

    (tags: excel concatenate visualbasic)

Creative Commons LicenseThe links for 2008-12-01 by Simon Scullion, unless otherwise expressly stated, is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Spain License.