Excel + Google Sheets · MID

Take text from the middle

Returns a number of characters starting at the position you choose.

The formula

What each part means

• A2The text
• 5Start at character 5
• 4Take 4 characters

Example

Step by step

1. Click cell B2.
2. Type the formula: =MID(A2, 5, 4)
3. Press Enter.
4. Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.

Where it works

• Every version of Excel
• Google Sheets
• Excel for the web (free)

The same formula in other languages

• English MID
• Español EXTRAE
• Português EXT.TEXTO