Question: In a worksheet, column A contains employee last names, column B contains their middle initials (if any), and column C contains their first names. Which tool can combine the last names, initials, and first names in column D without using a worksheet formula?
- Concatenation
- Columns to Text
- Flash Fill
- AutoFill
Answer: The correct answer of the above question is Option A:Concatenation