How to Use LEFT, RIGHT, and MID in Excel

LEFT, RIGHT, and MID extract specific characters from text. They help when imported data arrives as combined codes, messy IDs, account strings, or labels that need cleanup before lookup or reporting.

Use these functions when the structure is predictable: the first three characters always mean region, the last four always mean year, or the middle segment always contains a project code.

The syntax

• text - the cell containing the text
• [num_chars] - how many characters to return
• start_num - the character position where MID should start

If A2 contains WEST-0426-INV, then:

returns WEST.

returns INV.

returns 0426.

Example: split invoice codes

Suppose your invoice export uses codes like:

EAST-1042-PAID
WEST-1188-DUE

You want separate fields for region, invoice number, and status.

Step 1. Extract the region

For EAST-1042-PAID, this returns EAST.

Step 2. Extract the invoice number

This starts at character 6 and returns 4 characters, so it returns 1042.

Step 3. Extract the status

For EAST-1042-PAID, this returns PAID. For WEST-1188-DUE, the same formula would be wrong because DUE has only three characters.

When these formulas break

These functions count character positions. They do not understand words, separators, or business meaning. Excel is just counting.

That means the formula can break if:

• one region has three letters and another has four
• invoice numbers change from four digits to five
• a source system adds a prefix
• spaces appear before or after the code

When the delimiter is reliable, newer Excel users may prefer TEXTSPLIT. LEFT, RIGHT, and MID are still useful when the layout is fixed and compatibility matters.

Common issues

Validate lengths and edge cases

Text extraction formulas assume a consistent shape. Before filling them down, check for blank cells, shorter-than-expected IDs, extra delimiters, and non-printing characters. LEFT and RIGHT return the requested number of characters, while MID starts at a position and takes a count; an incorrect position can silently produce a plausible but wrong code.

Keep the raw field beside the extracted columns until the cleanup is approved. If the layout changes often, use delimiter-aware functions or Power Query instead of hard-coded character positions. Add a simple validation column that compares the reconstructed text with the source or flags unexpected lengths, then review the exceptions before using the extracted values in a lookup.

The Griddy way

Text extraction is easy for one row. A messy export with 600 rows is a different story.

"Split these invoice codes into region, invoice number, and status columns"

Griddy can inspect the pattern, choose fixed-position or delimiter-based formulas, and fill the cleaned fields across the sheet.

Sources

• Microsoft Support: LEFT function
• Microsoft Support: MID function