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:

    Read 8225 times
    Published in Microsoft Excel
    Tagged under
    105 comments
    Read more...
    Wednesday, 03 August 2016 10:14

    How to convert CSV date format into MySQL date format in Excel

    Written by
    Rate this item
    (2 votes)

    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

    Read 86118 times
    Published in Microsoft Excel
    Tagged under
    3400 comments
    Read more...
    Thursday, 11 February 2016 19:02

    How to change a text to lower case and replace space with a dash in Excel

    Written by
    Rate this item
    (1 Vote)
    How to change a text to lower case and replace space with a dash in Excel

    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.

    Read 13840 times
    Published in Microsoft Excel
    Tagged under
    86 comments
    Read more...
    Monday, 25 January 2016 10:34

    How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell

    Written by
    Rate this item
    (4 votes)
    How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell

    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.

    Read 64508 times
    Published in Microsoft Excel
    Tagged under
    1408 comments
    Read more...