ASSIGNMENT – 25

Use of Formula – CONCATENATE / CONCAT

Topic: Joining Text from Multiple Cells

Table 1 – Employee Details

Enter the following data in Excel:

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

Questions – Create Full Name

Q.1 Create the Full Name by joining First Name and Last Name with a space.

Use: CONCATENATE

Q.2 Create the Full Name of Aarav Sharma.

Q.3 Create the Full Name of Priya Mehta.

Q.4 Create the Full Name of Ananya Singh.

Q.5 Create the Full Name of Simran Kaur.

Q.6 Create the Full Name of Pooja Saini.

Table 2 – Create Employee Information

Enter the following data:

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

Questions – Create Employee Information

Q.7 Create Employee Information in the following format:

Aarav Sharma – Sales

Q.8 Create Employee Information for Priya Mehta.

Q.9 Create Employee Information for Rohan Kapoor.

Q.10 Create Employee Information for all employees using CONCATENATE / CONCAT.

Formula Examples

1. Create Full Name using CONCATENATE

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

=CONCATENATE(B2," ",C2)

2. Create Full Name using CONCAT

Modern Excel:

=CONCAT(B2," ",C2)

3. Create Employee Information using CONCATENATE

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

4. Create Employee Information using CONCAT

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

5. Create Employee Information using & Operator

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

Expected Format

For example:

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

Skills Covered

After completing this assignment, students will learn:

  • CONCATENATE

  • CONCAT

  • & Operator

  • Joining text from multiple cells

  • Adding spaces between text

  • Adding symbols and text between cell values

  • Creating Full Names

  • Creating combined employee information

  • Using formulas with multiple cell references

PreviousNext