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

Excel-Functions-PostersI have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP

Find out more about the posters here


Similar Posts:

Leave a comment

Your email address will not be published. Required fields are marked *