The Excel Function of the month is
CONCATENATE
Concatenate 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.
Here we are joining the contents of A1, B1 and C1. The result of the function is seen in cell E1.
But what about the lack of spaces? Just add them in like this:
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”…
I 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
Be the first to comment