Concatenate in Excel

In Excel you can concatenate data in a new cell.

In the example below you can see how to use the concatenate-function to concatenate street and house number into an address with a space between street and housenumber.