Excel CONCATENATE Function Basics
The Excel CONCATENATE Function will knit together as many text ranges as you want to put together. Each parameter of the CONCATENATE function is a single range and you cannot concatenate a range array (multiple cells). In practice I do not use the CONCATENATE function because I prefer to use the ampersand (&) sign as a quick and easy way to put text together. To be honest typing one ampersand sign is far more efficient than typing the word CONCATENATE. I have not noticed any speed difference between the two methods but I have not rigorously tested this theory.
Excel CONCATENATE Function – Adding Text Strings
There is no reason that the Excel CONCATENATE Function should be limited to just text ranges, you can also use hard coded text strings, spaces and character functions such as quotes and line feeds (a.k.a. ENTER key).
In this example we are creating a new text range of <LAST_NAME>, <FIRST_NAME>. In this example we have to enter the comma as a constant.
Excel CONCATENATE With Special Characters
One frustrating part of creating concatenated text is inserting special characters that have other meanings such as quote characters or line feed characters. The easiest way of inserting special characters is using the Excel CHAR Function. Each character has its own numeric code that ranges from 0 to 255. For example the quote character is CHAR(34) and the life feed (ENTER key) is CHAR(13). In this example we are going to put quote characters around our <FIRST_NAME>&<FIRST_NAME> field.