Better Sheets

How to Use MID() in Google Sheets

Description

Returns a segment of a string.

How To Actually Use MID() in Sheets

MID(string, starting_at, extract_length)

Try MID yourself

In cell B1, use the MID function to extract 4 characters from the string in cell A1, starting at the 3rd character. The result should display the correct segment of the string.

Your formula

Hints (2)

Locale Separator ,

Official Docs

3 Better Sheets Tutorials

Wordle in a Google Sheet | Work in Progress

Building a clone of Wordle inside Google Sheets.

Intermediate

COLUMN() IF() INDEX() MID() TEXT()

How To Replace First Word | Great for SEO keyword research

Replace and find word will search your documents for specific text, replaced with different text, or you can replace it with something else.

Beginner

MID()

5 Ways to Create Coupon Codes | Create UUIDs

Generate Coupon Codes with 5 Levels of Difficulty - From Copy-Pasting to Advanced Google Sheets Formulas. Get up to thousands of unique codes easily! Watch now for coupon mastery inside of Google Sheets.

CHAR() DEC2HEX() MID() RANDBETWEEN()

Transcript-matched member videos for MID(). Click through to watch.

Browse more tutorials

Hardest Formula: SumIF | Addition Based on Dates / Values

Demystifying the SumIF Formula. Add up your values based on a condition,...

SUMIF() UNIQUE()

Write Apps Script to Create a New Google Sheets Formula

Create a brand new custom formula in Apps Script. We'll do this for our ...

What is this Ampersand Doing in Google Sheets?

What is "&" doing in this formula? MONTH(A1&1) Do you know why this is s...

CONCAT() DATE() MONTH() VALUE()

Ultimate Checklist in Google Sheets

how to create and customize checklists using Google Sheets. I show you h...

Beginner

COUNTA() COUNTIF() IF() SPARKLINE()

Unlock these tutorials

Learn more about the MID() formula:

Generate a MID() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses MID(). 2 free AI generations, no signup. Members get unlimited use.

Generate a MID() formula