Concatenate Dates with Text in MS Excel With Example.

Concatenate Dates with Text, How to Write Date with Text in Excel Worksheet Cell? Easiest way to concatenate dates with text with example in MS Excel





Last week my friend ask me how to concatenate Date with a String or Text, but that time I couldn't give him the solution because I was on Himachal Trip. So now here we will learn how to Concatenate a text with another formate value like Date, Number, time etc.

If you have a column containing dates in your Excel Worksheet and another column that contain some text. Now you want to concatenate date with text, but if you concatenate the date with text then what will be the format of Result you will get after concatenation.

So to concatenate text with date you need to change the format of your date column. You need to convert your date into text format.

How to convert Date format into Text Format in Microsoft Excel Worksheet, How to use TEXT Function in MS Excel Worksheet or What Excel TEXT Function do?

The Microsoft Excel TEXT function returns a value converted to text with a specified format.
To change or convert Date format into Text format you will need to apply "TEXT" Formula or Function.

What is the SYNTAX of TEXT Function?



Syntax

The syntax for the Microsoft Excel TEXT function is:
TEXT( value, format )

Where
 
value is the value to convert to text.
format is the format to display the results in.

Here is an example to concatenate date and text. In B Column from B3:B10 we have some date values and in C Column from C3:C10 we have some text values. Now to Concatenate both the values B3:B10 and C3:C10 use the given below Formula in cell D3 and Fill down the formula.

Formula:- =CONCATENATE(TEXT(B3,"dd-mm-yyyy"),C3)