LEFT, RIGHT, MID in Google Sheets - Step-by-Step Guide

Introduction

These functions help you get parts of text from a cell. LEFT takes characters from the start, RIGHT takes from the end, and MID takes from the middle. They are useful when you want to split or extract specific pieces of text.

When you want to get the first few letters of a product code to identify its category.

When you need the last digits of a phone number for quick reference.

When you want to extract a middle part of a text like a date or ID from a longer string.

When you have a full name and want to get just the first name or last name.

When you want to separate parts of a code that are combined in one cell.

Steps

Step 1: Click

- cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

You start entering the formula

💡 Start with =LEFT, =RIGHT, or =MID depending on what part you want

Step 3: Enter

- formula bar

Formula appears in the cell showing the extracted text

Step 4: For LEFT, type

- formula bar

Formula looks like =LEFT(A1, 7) to get first 7 characters from cell A1

Step 5: For RIGHT, type

- formula bar

Formula looks like =RIGHT(A1, 3) to get last 3 characters from cell A1

Step 6: For MID, type

- formula bar

Formula looks like =MID(A1, 8, 4) to get 4 characters starting from 8th character in A1

Before vs After

Before

Cell A1 contains text 'Invoice2024XYZ'

After

Using =LEFT(A1, 7) shows 'Invoice', =RIGHT(A1, 3) shows 'XYZ', =MID(A1, 8, 4) shows '2024'

Settings Reference

Number of characters

📍 Second argument in LEFT and RIGHT functions

Defines how many characters to extract from start or end

Default: No default, must specify

Start position

📍 Second argument in MID function

Defines the position in text where extraction begins

Default: No default, must specify

Number of characters (MID)

📍 Third argument in MID function

Defines how many characters to extract starting from start position

Default: No default, must specify

Common Mistakes

Not specifying the number of characters in LEFT or RIGHT

The formula will return an error because the function needs to know how many characters to extract

Always include the number of characters as the second argument, like =LEFT(A1, 3)

Using MID with a start position outside the text length

The formula returns an empty string because it starts beyond the text

Check the text length and use a start position within that range

Using negative numbers for number of characters

Functions do not accept negative numbers and will give an error

Use only positive numbers for character counts

Summary

LEFT, RIGHT, and MID extract parts of text from cells.

LEFT gets characters from the start, RIGHT from the end, MID from the middle.

Always specify how many characters to extract and where to start for MID.