Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools

Blog

Extracting a Portion of Cell Contents using LEFT, RIGHT, and MID

5/13/2019

Comments

 
Picture
When you have a string of texts and numbers and you need to extract characters out of it, you can use the LEFT, RIGHT, and MID functions.

LEFT and RIGHT have two parameters: the cell where the values will be taken from, and the number of characters to extract either from LEFT or RIGHT, respectively.  (See image, column B and C.)

On the other hand, MID has a middle parameter (Column D of image) that determines at what position it should get characters from.  Remember that unlike LEFT and RIGHT that has a fixed starting position as to where to get characters from, MID starts somewhere in the middle, therefore, requiring this parameter that points out where it should begin getting characters from the left side.

In the example:

=MID(A2,6,3)
 
The 6 represents the 6th character from the value:
2015-800-IT
 
The 3 is num_chars.  From the start_num, how many characters  will be extracted:
 
2015-800-IT
Comments
    View my profile on LinkedIn

    Archives

    April 2020
    May 2019
    September 2017

    Categories

    All
    Excel Functions
    Word Features

    RSS Feed

Home

Courses

Public Classes

Contact

Copyright © 2022