olztracks.blogg.se

#1 – Combine Text with Dates Using Concatenate Function

Ok, let’s go ahead and learn how to merge dates in excel. Yes, it is different when you are merging dates in excel because it won’t give you the exact result that you want. You must be wondering whats the big deal about merging dates when you already know how to merge two or more cells string values. In this article, I will take you through the concept of merging dates with concatenate function Concatenate Function The CONCATENATE function in Excel helps the user concatenate or join two or more cell values which may be in the form of characters, strings or numbers. To concatenate date in excel with other values we can use & operator or also known as concatenate operator or the inbuilt concatenate function in excel, for example, if we use =”ABC”&NOW() this will give us the output as ABC as a result and in similar fashion we can use the concatenate function.