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:
Where text is a text string, cell reference or formula-driven value.
The following examples show the CONCATENATE FUNCTION in action:
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.