Question

Use the CONCAT function to combine the text in cells C5, B12, C7, J12, and C8 (in that order) to create the Text Stamp in cell K12. The Text Stamp in cell K12 should read Employee number 18 entered the server room at 00:53:02 today. Use absolute cell reference when necessary so that the function can be reused. Copy and paste your function to complete the Text Stamp column of the table.

A) Excel Function Provided
B) Excel Function Not Provided

Answer 1

A good way to use the CONCAT function in the given question would be as follows; =CONCAT use parentheses to enclose the following - "Employee number", C5, "entered the room number at" B12, ":", ", C7, ":", J12, "today"

How to use the CONCAT function

We can use the CONCAT function to join the elements in different cells. So, the cell values we have in the above instance represent different data.

We can use the CONCAT function to join all of these values and simply copy and paste the same instruction into other cells. This saves time and effort. So, for the given question we can concatenate as shown above.