How to Extract Text Using the LEFT, RIGHT, and MID Functions in Excel

When you download raw data from a massive corporate database, the information is often clumped together in highly annoying formats. For example, a single cell might contain an employee’s full ID code: “ENG-8492-BOSTON”. If you only want to extract the department (“ENG”), the ID number (“8492”), or the location (“BOSTON”) into their own separate columns, you cannot manually retype 10,000 rows of data. To force Excel to mathematically slice the text string and extract highly specific characters, you must use the LEFT, RIGHT, and MID parsing functions.

Extracting Characters with LEFT and RIGHT

The LEFT and RIGHT functions are edge-parsers. They start at the absolute boundary of a text string and slice inward.

The LEFT Function:
If cell A2 contains “ENG-8492-BOSTON”, and you want to extract just the 3-letter department code (“ENG”) sitting at the very beginning of the string, you command Excel to start at the absolute left edge and grab exactly 3 characters.

=LEFT(A2, 3)

The formula instantly slices the string and outputs the clean word “ENG”.

The RIGHT Function:
If you only want the location code (“BOSTON”) sitting at the very end of the string, you command Excel to start at the absolute right edge and grab exactly 6 characters.

=RIGHT(A2, 6)

The formula instantly slices the string backward and outputs the clean word “BOSTON”.

Surgically Extracting Data with the MID Function

The MID function is a highly precise surgical tool. It allows you to completely ignore the edges of the string and extract a specific block of data buried deep inside the middle of the cell.

Unlike LEFT and RIGHT, which only require a character count, the MID function requires exactly three arguments: =MID(text, start_num, num_chars).

If you want to extract the 4-digit ID number (“8492”) from “ENG-8492-BOSTON”, you must execute a strict mathematical calculation:

1. start_num: You must count how many characters into the string the number begins. E, N, G, and the hyphen (-) equal 4 characters. Therefore, the number 8 begins exactly at character position 5.
2. num_chars: You only want the 4 digits, so you command Excel to grab exactly 4 characters.

=MID(A2, 5, 4)

The formula instantly bypasses the first four characters, drives a scalpel directly into position 5, extracts exactly four characters, and perfectly outputs the clean number “8492”.