Leading the way in Microsoft Office Development

Excel

Concatenating Text

Excel uses the ampersand "&" character for string concatenation.

The concatenation is a word that means to join two strings together.

This can be used in formulas to combine the contents of multiple cells.

SS

There is also a CONCATENATE() function.

You can add spaces by enclosed them in speech marks

SS

Alternatively you can use the CHAR(32) to represent a space

SS