Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Excel Functions: What is the MID Function & How to Use It

September 14, 2016 by Tyrone Pernsley

mid-function-featured-imageExcel offers a variety of different formulas and functions for everyday use. This week, we will focus on the MID function. This function allows you to isolate a sub-string of data within a larger string in a new cell. The syntax is simple and straightforward, making it an ideal function for quick tasks.

There are many reasons and ways you will use the MID function. Today’s example comes directly from a Learn Excel Now fan who emailed us with an issue he was having.

Brian wrote:

“The most boring and time-consuming task I have at work is to pull the processing numbers out of the sales database to send to our warehouse team. The sales report exports into Excel and all of the order info is jammed together on one line. I have to go line by line and rewrite the individual processing number. Depending on our daily orders, it can take me several hours to finish. And with so many lines to go through, it’s really easy to miss a number or get the line wrong. My boss has talked to me about it. Can you help?”

Yes, Brian, we are here to help. Let’s explore how the MID function can be used to help your task.

The syntax for the MID function is:

=MID(Text,Start_number,Number of Characters)

Simply put, this is saying: pull the data out of this range (text), starting on character (Start_Number) going this many characters after it (Number of Characters).

This spreadsheet will be used to approximate Brian’s report:

mid-function-image-1

As you can see, the Processing Number starts on character 13 and is 5 characters long. Thus, the way we would write this formula is:

=MID(A3,13,5)

mid-function-image-2

Now the processing number is nice and clear on its own line:

mid-function-image-3

IMPORTANT: In this example, each line has same the number of characters. So, you can copy and paste all the way down, however, for lines with different numbers of characters, you will need to count to the starting and end points individually.

mid-function-image-4

For Brian, using the MID function will save a ton of time and ensure accuracy.

We at Learn Excel Now hope you found this week’s tip on the MID function useful. There are many times this will come in handy, you just have to recognize the opportunity!

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter.

Kevin – Learn Excel Now

Comments

  1. Spencer says

    September 15, 2016 at 8:05 am

    Great tip, didn’t know about this formula before!

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In