Formulaes and Functions - Concatenation

Concatenation joins several text strings into one text string.  Notice how cells C1 and D1 have been joined with a hyphen, and text added at the end, so that in E1 there is a new text string.  The cells have been concatenated together.

To use the Concatenate function click on Insert on the menu bar.  Click on All, then scroll down to Concatenate.

In the Concatenate box add the cell names and characters as required.   Watch how the formula bar changes.

When one cell has been concatenated as required, pull down using the autofill function to complete the whole column.

This work may be freely copied for non-commercial use only. Copyright © Pam Miller