02/12/2008

links for 2008-12-01

  • 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)

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 5 other subscribers.

TagsLinks

Simon Scullion Written by:

Question everything. Reinventor. Sailor. Newbie Triathlete. Dad. Chief of Transformation @ Zapiens

skype_profile

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

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