Using the CONCATENATE Function in Excel: A Complete Guide
Table of Content:
CONCATENATE Function in Excel
The Concatenation function in Excel is a text function that allows you to combine two or more text strings into one string.
The syntax of the CONCATENATE function is as follows:
<span class="pln"> CONCATENATE</span><span class="pun">(</span><span class="pln">text1</span><span class="pun">,</span><span class="pln"> </span><span class="pun">[</span><span class="pln">text2</span><span class="pun">],</span><span class="pln"> </span><span class="pun">[</span><span class="pln">text3</span><span class="pun">],</span><span class="pln"> </span><span class="pun">...)</span><span class="pln"> </span>
where:
- "text1" is the first text string that you want to concatenate.
- "[text2]" is an optional argument that represents additional text strings that you want to concatenate.
Alternatively, you can use the "&" operator to concatenate text strings in Excel. The syntax for using the "&" operator is as follows:
<span class="pln"> text1 </span><span class="pun">&</span><span class="pln"> </span><span class="pun">[</span><span class="pln">text2</span><span class="pun">]</span><span class="pln"> </span><span class="pun">&</span><span class="pln"> </span><span class="pun">[</span><span class="pln">text3</span><span class="pun">]</span><span class="pln"> </span><span class="pun">&</span><span class="pln"> </span><span class="pun">...</span><span class="pln"> </span>
where:
- "text1" is the first text string that you want to concatenate.
- "[text2]" is an optional argument that represents additional text strings that you want to concatenate.
For example, if you have two text strings, say "Hello" and "world!", and you want to concatenate them, you can use the following formula using the CONCATENATE function:
<span class="pln"> </span><span class="pun">=</span><span class="pln">CONCATENATE</span><span class="pun">(</span><span class="str">"Hello"</span><span class="pun">,</span><span class="pln"> </span><span class="str">" "</span><span class="pun">,</span><span class="pln"> </span><span class="str">"world!"</span><span class="pun">)</span><span class="pln"> </span>
Or, you can use the following formula using the "&" operator:
<span class="pln"> </span><span class="pun">=</span><span class="str">"Hello"</span><span class="pln"> </span><span class="pun">&</span><span class="pln"> </span><span class="str">" "</span><span class="pln"> </span><span class="pun">&</span><span class="pln"> </span><span class="str">"world!"</span><span class="pln"> </span>
In both cases, the result will be "Hello world!".
The Concatenation function can be very useful when you need to combine text strings from different cells or add a space or punctuation between two text strings.