To add a date to the text - To add a date to the text we must first convert it to text using the TEXT function. The TEXT function also can be use to format the date in a specific format.
- For example if I wanted a date in the format - 09/12/2008, I would enter the Text function as - TEXT(Cell Address, "dd/mm/yyyy")
- To incorporate the Date into the cell, simply type the formula as follows - = A2 & " " & B2 & " " & C2 & " was born on " & Text(D2,"dddd, dd mmmm yyyy")
- The result will be - Mr John Harvest was born on Sunday, 12 October 1980..
The good part about
Excel Text concatenation is that you can use it with Excel Database lists and combine multiple cells together and then use the data in the list with programs like Microsoft Word to do a mail merge.