Example Using the CONCATENATE Function
To illustrate the usage of this function, we’ll return to the sample table from the first section of this article. Those who are using the CONCATENATE function for the first time may try to use one of the following formulas to join the information contained in cells A2 and B2.
A2 & B2
However, this type of construction will cause the first and last names to be joined without a space between, as shown in the screenshot below.
Instead, we need to specifically instruct the function to insert a space between the two fields using “ “ as an additional text string. That is, our formula would appear as one of the following.
CONCATENATE(A2, “ “, B2)
A2 & “ “ & B2
This revised correction of the formula is shown below.
Now, to apply this function to the other rows in the table, you can either copy and paste the formula into all other cells in the new column, or you can use Excel’s column fill feature.
Additional Resources: For more tips and tricks, be sure to take a look at the other Microsoft Excel tutorials that can be found here on Bright Hub’s Windows Channel. Learn more about various charts and graphs, how to protect your shared files with a Creative Commons License, and how to save an Excel object as a picture. More articles are being added on a regular basis so check back often!