How to use MID formula in excel ?
- 8 years ago
What does it do?
*This function picks out a piece of text from the middle of a text entry.
*The function needs to know at what point it should start,
and how many characters to pick.
*If the number of characters to pick exceeds what is available, only the available
characters will be picked.
Syntax
=MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick)
*This function picks out a piece of text from the middle of a text entry.
*The function needs to know at what point it should start,
and how many characters to pick.
*If the number of characters to pick exceeds what is available, only the available
characters will be picked.
Syntax
=MID(OriginalText,PositionToStartPicking,NumberOfCharactersToPick)