Excel Concatenate Function Tutorial - How to Join Text in Excel
The CONCATENATE function is used to join different texts or cell contents into one text.
The CONCATENATE function can join up to 255 items, the syntax is =CONCATENATE(text1,[text2],…)
At least one item is required for CONCATENATE function i.e., text1.
Items can be text, numbers or cell addresses.
Follow the steps below to practice using the concatenate function in Excel 2013.
STEP 1: Select a cell where the concatenate text will appear.
Type the symbol " = " and click on insert function symbol that is just before the formula bar to get the “insert function” dialog box
Make sure the “select a category” field contains “All” or “Text” Select the function “CONCATENATE” and click OK. In the function arguments dialog box (shown below)
Keep cursor in “Text1” field, select cell “A1” then keep the cursor in “Text2” field and type symbol “ _ ” through key board and then keep the cursor in “Text3” field and select cell “B1” and click OK.
Apply the formula by clicking and dragging the right lower corner.
Thus getting the required text in different cells to be concatenated to a single cell.
Step 2: The formula can be typed in the syntax of excel as shown below.
Step 3: The alternative way of concatenating the text is using the “ & “ symbol.
In concatenate, the most important thing to remember is the text that needs to be concatenated should be in quotations “ ” , whereas the cell addresses are not in quotations.