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)
Formatting
No special formatting is needed.
Example-1
The following table uses the =MID()
function to extract a post code from a branch ID used by a company.
It is assumed that all branch ID's follow the
same format with the letters identifying the postal region being in the 5th and
6th positions.
Example-2
This example shows how to extract an item which
is of variable length, which is inside a piece of text which has no standard
format, other than the required text is always between two slash / symbols.
No comments:
Post a Comment