Stump the Panel » End Users and Information Workers

Using Calculated Column to Add Content from Two Other Columns

(3 posts)
  • Started 3 days ago by JPHowy
  • Latest reply from Dessie Lunsford

  1. JPHowy
    Member

    Can I use the Calculated column (C) in a list to equal the content from column A and column B? For example, column A contains AC201 and column B contains 62; how I can use the Calculated column C to equal AC20162? Thanks! Cheers, Jason

    Posted 3 days ago #

  2. JPHowy
    Member

    Aha! I figured it out :-) It's the & sign...

    =[Column A]&[Column B]

    Posted 3 days ago #

  3. Dessie Lunsford
    Moderator

    Nice job finding the answer!

    The "&" sign (ampersand) is used to concatenate strings together, and can (as you found out) be used to merge two columns values into a new column value.

    The alternate method is to use the "CONCATENATE()" function to merge up to 30 different values.

    Example (using your question):
    =CONCATENATE([Column A],[Column B])
    Displays a result of: "AC20162"

    - Dessie

    Posted 2 days ago #

RSS feed for this topic

Reply

You must log in to post.