ASSIGNMENT – 37

USE OF LEFT, FIND, LEN, LOWER & NETWORKDAYS

Objective

In this assignment, you will learn how to use:

  • LEFT – to extract characters from the left side of text.

  • FIND – to find the position of a character or space.

  • LEN – to count the total number of characters.

  • LOWER – to convert text into lowercase.

  • NETWORKDAYS – to calculate working days between two dates.

PART A – LEFT FUNCTION

Table 1 – Extract Characters from Text

Text Characters Required Left String
Computer 3  
Education 4  
Microsoft 5  
Excel123 6  
Training 2  

LEFT Syntax

=LEFT(text,num_chars)

Example

To extract the first 3 characters from Computer:

=LEFT(A2,3)

Q1. Use the LEFT function to extract the required number of characters from each text.

PART B – LEFT + FIND

Table 2 – Extract First Name

Full Name First Name
Rahul Sharma  
Neha Kapoor  
Amit Verma  
Priya Singh  
Karan Mehta  

Q2. Extract the First Name from each Full Name using LEFT + FIND.

Hint

The position of the space can be found using:

=FIND(" ",A2)

Then combine it with LEFT:

=LEFT(A2,FIND(" ",A2)-1)

PART C – LEN FUNCTION

Table 3 – Find Text Length

Text Length
Rahul Sharma  
Excel Training  
Computer  
Microsoft Excel  
Student  

LEN Syntax

=LEN(text)

Q3. Find the total number of characters in each text using LEN.

Note: LEN counts spaces as characters.

PART D – LOWER FUNCTION

Table 4 – Convert Text to Lowercase

Upper Case Text Lower Case
RAHUL SHARMA  
NEHA KAPOOR  
EXCEL TRAINING  
COMPUTER COURSE  
MICROSOFT EXCEL  

LOWER Syntax

=LOWER(text)

Q4. Convert all text into Lower Case using the LOWER function.

PART E – NETWORKDAYS FUNCTION

Table 5 – Calculate Working Days

Start Date End Date Working Days
01-09-2026 07-09-2026  
10-09-2026 18-09-2026  
01-10-2026 15-10-2026  
05-10-2026 20-10-2026  
12-10-2026 30-10-2026  

NETWORKDAYS Syntax

=NETWORKDAYS(start_date,end_date)

Example

=NETWORKDAYS(A2,B2)

By default, NETWORKDAYS counts Monday to Friday as working days and excludes Saturday and Sunday.

Q5. Calculate the number of working days between the Start Date and End Date.

BONUS PRACTICE QUESTIONS

Q6. From the name “Aarav Mehta”, extract only the First Name using LEFT + FIND.

Q7. Find the length of “Advanced Excel Course” using LEN.

Q8.Convert:

“ADVANCED EXCEL TRAINING” into lowercase using LOWER.

Q9. Calculate the working days between:

01-11-2026 and 15-11-2026 using NETWORKDAYS.

Q10. Integrated Practice

Create the following table:

Full Name First Name Name Length Lower Case Name
Aarav Sharma      
Riya Kapoor      
Karan Mehta      
Neha Singh      
Rahul Verma      

Use the following functions together:

  • LEFT

  • FIND

  • LEN

  • LOWER

Suggested Formulas

First Name:

=LEFT(A2,FIND(" ",A2)-1)

Name Length:

=LEN(A2)

Lower Case Name:

=LOWER(A2)

Learning Outcome

After completing this assignment, students will be able to:

  1. Extract characters using LEFT.

  2. Find the position of a space or character using FIND.

  3. Combine LEFT and FIND to extract First Names.

  4. Count characters using LEN.

  5. Convert text to lowercase using LOWER.

  6. Calculate working days using NETWORKDAYS.

  7. Combine multiple text functions in a practical Excel worksheet.

PreviousNext