Displaying items by tag: excel

    Subscribe to this RSS feed
    Friday, 30 November 2001 00:00

    Using Concatenate Function in Excel

    using-concatenate-function-in-excel

    Excel CONCATENATE function

    The CONCATENATE function in Excel allows different pieces of text to join into one or combine values from several cells into one cell.

    The syntax of Excel CONCATENATE i:

    CONCATENATE(text1, [text2], …)

    Where text is a text string, cell reference or formula-driven value.

    The following examples show the CONCATENATE FUNCTION in action:

    Example 1: Concatenating the values of several cells:

    Published in Microsoft Excel
    Read more...