Excel’s CONCATENATE functions joins two or more text strings into one string. The item can be a text value, number, or cell reference.
If you add a double quotation with a space in between ” ” then this will add a space between the texts selected on either side.
You can also add a line break in between each text string. This is done by entering the CHAR(10) function in between each text string/argument. You will then need to select WRAP TEXT in order to see each text on a separate line.
See how easy this is to implement this by using employee data on the example below.