MID

MID the substring of the string s starting at position position consisting of length characters

Synopsis

MID(s,position,length)

Arguments

s: the string

position: the starting position

length: the number of characters to return

Microsoft Excel Compatibility

This function is Excel compatible.

OpenDocument Format (ODF) Compatibility

This function is OpenFormula compatible.

See also

LEFT, RIGHT, LEN, LEFTB, MIDB, RIGHTB, LENB.