What is the Microsoft Excel “CONCATENATE” function used for?
- it is used to combine the data from one or more columns into a single column
- it is used to combine data from multiple worksheets in Excel in order to have the data you need to inform the analysis
- it is used to filter blank cells in a given column
- it is used to sum up the values in a given column
| Answers Explanation & Hints:
The function “CONCATENATE” is used to combine the data from one or more columns into a single column. When you concatenate cells in Excel, you combine only the contents of those cells. In other words, “CONCATENATE” in Microsoft Excel is the process of joining two or more values together. This method is often used to combine a few pieces of text that reside in different cells (technically, these are called text strings or simply strings) or insert a formula-calculated value in the middle of some text. |