ASSIGNMENT – 25

CONCATENATE / CONCAT — Answer Key

Table 1 – Full Name

Formula

If First Name is in B2 and Last Name is in C2:

=CONCATENATE(B2," ",C2)

Or:

=CONCAT(B2," ",C2)

Or using &:

=B2&" "&C2

Drag the formula down from D2 to D11.

Completed Table

EMP ID FIRST NAME LAST NAME FULL NAME
E101 Aarav Sharma Aarav Sharma
E102 Priya Mehta Priya Mehta
E103 Rohan Kapoor Rohan Kapoor
E104 Ananya Singh Ananya Singh
E105 Karan Verma Karan Verma
E106 Neha Gupta Neha Gupta
E107 Rahul Jain Rahul Jain
E108 Simran Kaur Simran Kaur
E109 Mohit Bansal Mohit Bansal
E110 Pooja Saini Pooja Saini

Question-wise Answers

Q.2 Aarav:
Aarav Sharma

Q.3 Priya:
Priya Mehta

Q.4 Ananya:
Ananya Singh

Q.5 Simran:
Simran Kaur

Q.6 Pooja:
Pooja Saini

Table 2 – Employee Information

Formula

If:

  • First Name = B2

  • Last Name = C2

  • Department = D2

Use:

=CONCATENATE(B2," ",C2," - ",D2)

Or:

=CONCAT(B2," ",C2," - ",D2)

Or:

=B2&" "&C2&" - "&D2

Completed Employee Information

EMP ID FIRST NAME LAST NAME DEPARTMENT EMPLOYEE INFORMATION
E101 Aarav Sharma Sales Aarav Sharma – Sales
E102 Priya Mehta Finance Priya Mehta – Finance
E103 Rohan Kapoor IT Rohan Kapoor – IT
E104 Ananya Singh HR Ananya Singh – HR
E105 Karan Verma Marketing Karan Verma – Marketing

Question-wise Answers

Q.7 Aarav Sharma

Answer: Aarav Sharma – Sales

Q.8 Priya Mehta

Answer: Priya Mehta – Finance

Q.9 Rohan Kapoor

Answer: Rohan Kapoor – IT

Q.10 All Employees

Employee Employee Information
Aarav Sharma Aarav Sharma – Sales
Priya Mehta Priya Mehta – Finance
Rohan Kapoor Rohan Kapoor – IT
Ananya Singh Ananya Singh – HR
Karan Verma Karan Verma – Marketing

Final Formula Reference

CONCATENATE

=CONCATENATE(B2," ",C2)

CONCAT

=CONCAT(B2," ",C2)

& Operator

=B2&" "&C2

Full Employee Information

=B2&" "&C2&" - "&D2

Key Point

The " " in the formula adds a space between First Name and Last Name, while " - " adds a hyphen with spaces before and after it.

PreviousNext