Friday, 30 November 2001 00:00

    Using Concatenate Function in Excel

    Written by
    Rate this item
    (1 Vote)

    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:

    Rate this item
    (1 Vote)

    In this article, you will find a simple way to format CSV dates ready to import in mySQL database

    Exported date fields from mySQL become strings in Excel CSV as follows 01/05/2016 00:00, The following simple tutorial explains how to convert the dates back into MySQL format

    Rate this item
    (1 Vote)

    In this article, you will learn the formula to change text to lower case and replace space by a dash.

    This can be useful when importing CSV file to a CMS like Joomla where articles titles need their respective aliases to be in lower case.

    Rate this item
    (4 votes)

    In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

    Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.