LEFT / RIGHT / MID
Extract part of a text string from the start, end, or middle.
LEFT, RIGHT, and MID pull a number of characters from a string — handy for codes, IDs, and parsing.
Excel
=LEFT(A2, 3)Google Sheets
=LEFT(A2, 3)How it works
- 1A2 is the source text.
- 23 is how many characters to take from the left.