PlayInfoBox

Home /Utilities /Excel Text Functions: LEFT, RIGHT, MID Basics

Excel Text Functions: LEFT, RIGHT, MID Basics

Tap a step below to see it explained in order.

  1. Extract from the left with LEFT

    Type something like =LEFT(A1,3) to pull a set number of characters starting from the beginning of the cell.

  2. Extract from the right with RIGHT

    Type something like =RIGHT(A1,4) to pull a set number of characters counting back from the end of the cell.

  3. Extract from the middle with MID

    Type something like =MID(A1,2,3) to grab characters starting at a position you choose, for the length you specify.

  4. Combine with LEN for flexibility

    Pairing these with LEN, which counts total characters, lets you trim text dynamically no matter how long the string is.

  5. Why this is useful

    Handy for pulling a birth date out of an ID number, splitting an area code from a phone number, or isolating any fixed-position chunk of text.

Grab only the part of the text you need

Long strings often carry more than one piece of information packed together β€” a name and a code, a date and a reference number. Rather than retyping the part you actually need, LEFT, RIGHT, and MID let you slice it straight out of the original cell, and the result keeps updating automatically as the source changes.

A few things worth knowing

All three functions treat their input purely as text, so they work the same whether the cell contains letters, numbers, or a mix of both β€” though a genuinely numeric result may need wrapping in VALUE() if you plan to do math with it afterward. If your data has inconsistent spacing, pair these functions with TRIM to avoid unexpected extra characters at the edges of your extraction.

Frequently Asked Questions

If the original text changes, does the extracted result update automatically?

Yes β€” since these functions reference the source cell rather than copying static text, any edit to the original instantly updates every formula built on it.

Can I extract text that includes numbers?

Yes. LEFT, RIGHT, and MID treat everything as text regardless of whether it looks like a number, so mixed alphanumeric strings extract exactly the same way as plain text.