How to Concatenate Date in Excel?
In this article, I will take you through the concept of merging dates with concatenate function. You must be wondering whats the big deal about merging dates when you already know how to merge two or more cells string values.
Đang xem: Concatenate date and text
Yes, it is different when you are merging dates in excel because it won’t give you the exact result that you want. Ok, let’s go ahead and learn how to merge dates in excel.
#1 – Combine Text with Dates Using Concatenate Function
Now we know how to VBA Concatenate. Assume you are working as a recruiter in a company, and you have recruited below employees in the current month.
You can download this Concatenate Date Excel Template here – Concatenate Date Excel Template
You have their employee ID, Name, Salary, Joining Date, and their respective department.
Note: Wherever we have typed a comma (,) we can replace it with & operator.
Things to Remember about Concatenate Date in Excel
We can select only one cell as the argument; we cannot select the rage of cells in concatenate function.Using the TEXT function, we can modify the numbers to Date, Time, or whatever the format we want.Ampersand is the alternative way we can combine instead of concatenating function.
This has been a guide to the Concatenate Date in Excel. Here we discuss how to use Concatenate keeping the date format in excel (using TEXT Function) along with practical examples and downloadable excel templates. You may also look at these useful functions in excel –