{"id":6641,"date":"2021-08-09T13:11:28","date_gmt":"2021-08-09T13:11:28","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=6641"},"modified":"2024-02-19T14:52:31","modified_gmt":"2024-02-19T14:52:31","slug":"concatenate-date-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/concatenate-date-in-excel\/","title":{"rendered":"How to Concatenate Date in Excel"},"content":{"rendered":"\n
More often than not, we can find ourselves in a situation where we need to merge our text in different cells into one cell.<\/p>\n\n\n\n
This can be pretty useful. For this, we can use CONCATENATE<\/strong> function.<\/p>\n\n\n\n This function is one of Excel’s Text Functions<\/strong>. It helps you to join two or more strings into one big string.<\/p>\n\n\n\n The formula of the function is:<\/p>\n\n\n\n As seen, it has two arguments:<\/p>\n\n\n\n Text1 (required)-<\/strong> Here we define the first thing that we want to merge. It can be in form of the text (it has to be within quotation marks to work), a cell reference, or a number.<\/p>\n\n\n\n Text2 (required)<\/strong>– Then we have to define other items that we want to merge. We can merge up to 255 items, and up to 8192 characters.<\/p>\n\n\n\n For our example, we will create a table in which we have three columns: Month, Day, and a Year.<\/p>\n\n\n\nExplaining the Concatenate Function<\/h2>\n\n\n\n
=CONCATENATE(text1, [text2], \u2026)<\/code><\/pre>\n\n\n\n
Using Concatenate to Merge the Date<\/h2>\n\n\n\n