Concatenate Formula. Use the operator to produce the exact same result. The concatenate function is a built in function in excel that is categorized as a string text function.
Example 2 we have three tables with a list of employees. Then enter the transpose formula in that cell transpose a1 a78. Concatenate in the current version of excel you can use the new concat function instead of concatenate.
Now in the formula bar press f9 to replace the formula with calculated values.
The concatenate function below concatenates the string in cell a1 the string and enclose text in double. Use the operator to produce the exact same result. In the above formulas a2 b2 c2 are the cells that you want to concatenate if there are more cells needed to be combine you just add the references after the formula such as. Concatenate stream population for a2 a3 is a4 mile concatenate b2 c2.
