Using the RIGHT, LEFT and MID Functions in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

Which formula would you use to capture the first 4 characters of the data string located in B4?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. Using the following string of characters, DLM343456B82, which formula will extract 343456? The data is located in cell B2.

2. The following string of characters is entered into cell D4, DLM343456B82. You would like to extract the last 3 characters and have them display in D5. What formula do you enter in D5?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

Quiz/worksheet questions will be in regard to things like uses of different Excel formulas, and the necessary formulas for certain desired outcomes. These questions will primarily come in the form of example problems.

Quiz & Worksheet Goals

These practice questions will be on:

  • A formula used to capture certain characters
  • The way different formulas are applied
  • Proper Excel formula structure

Skills Practiced

  • Information recall - access the knowledge you've gained regarding Excel's functions
  • Interpreting information - verify that you can read information regarding character extraction in Excel and interpret it correctly
  • Reading comprehension - ensure that you draw the most important information from the related lesson on Excel's Right, Left, and Mid functions

Additional Learning

Watch our associated video tutorial, Using the RIGHT, LEFT, and MID Functions in Excel, to learn an even greater amount in regard to Excel. With this lesson, expect to be taught more about:

  • Data extraction
  • The properties of each function
  • Uses of each function
  • Each function's formula