Microsoft Excel - About Excel Formula

In Excel, the Concatenate function allows you to join 2 or more strings together.

The syntax for the Concatenate function is:

Concatenate( text1, text2, ... text_n )

There can be up to 30 strings that are joined together.

Applies To:

• Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Concatenate(A1, A2)	would return "Alphabet"
=Concatenate("Tech on the ", "Net")	would return "Tech on the Net"
=Concatenate(A1, "bet soup")	would return "Alphabet soup"