The difference between CONCATENATE and TEXT CONCATENATE is actually primarily that the TEXT CONCATENATE function offers the extended possibility to specify a space right at the beginning of the function, with which the values of the individual cells are to be separated from one another, instead of simply lining up all the character strings together.
So much for the basic functionality of concatenation in Excel. But now we want to do what the title of this tutorial says. We want to create a whole sentence in a single target cell from different individual values that are each in a cell.
Our sample table now shows a total of six columns with surname, first name, place of birth, birthday, time and a result column. The aim should be to bring the values from the individual cells into a meaningful sentence using the TEXTCONCATENATE function in combination with formatted values, which is then displayed in a cell. As a result, the table should look like the following figure.
see fig. (click to enlarge)