Extract Text using MID
Pull characters from the middle of a string.
You will learn to
- Use a start position and length
How it works
MID(text, start_num, num_chars) returns characters from the middle. =MID(A2,4,4) starts at character 4 and returns 4 characters: "2024".
=MID(A2,4,4)