What is Concatenate

Concatenate is a function in excel that allows you to merge together cells. This saves you time in not needing to retype the contents of two cells into one.

How to use it?

Go to insert a function. And find the concatenate function in the list of functions available.

You will then be shown the below options.

See how you can choose many cells to merge, if you wanted to. And to the right of the screen, you can see the result of the merged cells. So in the example BMWRed.

The purpose of this function is to allow user to easily combine data. For example, merging a first name with a surname, or adding a prefix or suffix to a string of data.