|
Have you ever needed to join two columns together as one?
You can easily and quickly join two or more text strings together as one. The syntax for the function is CONCATENATE(text1,text2,...).
How does it work?
Scenario: you have employee last names in one column and first names in a second column and you would like to join the first and last names together as one into a third column. See Figure 1
Click in the column cell you want the information to be joined and type your formula.
Formula example: =CONCATENATE(B5," ",A5)
In the above example B5 represents the first cell to join. In the formula B5 is being joined with a space before it joins with A5. This is accomplished in the formula by typing an open quote followed by pressing the spacebar on your keyboard to create the space and then closing the space in the formula with a closed quote. The last part of the formula (A5) is specifying the cell that B5 is to be joined with. The end result will be a third column containing the first and last names joined together with a separating space.
If you would like to view a flash video of this tip please use the link below:
Note: The video clip is a flash clip which requires the Adobe Flash Player. If you do not have the player you can download the player using the link: Adobe Flash Player. Dependent upon your company's download policies you may or may not be able to download the player.
Have a great week!
|
