Excel Function of the Month – CONCATENATE


The Excel Function of the month is

CONCATENATE

Description

excel-CONCATENATE-001Concatenate means to combine. This function joins the contents of cells together. It is very useful when creating usernames and passwords, ID codes or even email addresses.

Usage

Here we are joining the contents of A1, B1 and C1. The result of the function is seen in cell E1.

CONCATENATE

But what about the lack of spaces? Just add them in like this:

CONCATENATE WITH SPACES

Another alternative [using the ampersand ‘&’] for adding something in a CONCATENATE function. We can use the …C1&“gmail.com”… instead of the …C1,“gmail.com”…


Check out my Excel posters for your classroom

Similar Posts: