ExcelHeroThe MID function
Takes characters from the middle of text.
In German Excel: TEIL
How to write it
=MID(text, start_num, num_chars)- text
- The text.
- start_num
- Where to start, counting from 1.
- num_chars
- How many characters.
💡 Asking for too many characters is fine: MID stops at the end.
Try it
Take the 4-digit number from the middle of the code in C2.
A
B
C
D
1
Full name
City
Code
Number
2
maya lopez
berlin
TS-1042-BLU
3
LEO KING
paris
HD-0077-RED
4
sam o’neil
Rome
MG-3150-GRN
It starts at character 4 and is 4 long.