Explain how to use the CONCATENATE function or the '&' operator to merge cells in Excel.
Instruction: Provide an example of how to combine the contents of two or more cells into one.
Context: This question assesses the candidate's ability to manipulate text data in Excel, a common requirement for data preparation and reporting.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
For the CONCATENATE function, you would use a syntax like this: =CONCATENATE(text1, [text2], ...). Here, text1, text2, etc., are the contents of the cells you wish to combine...