Documentation/How Tos/Calc: MID function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 08:12, 30 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


MID

Returns text from the middle of a text string.

Syntax:

MID(text; start; number)

returns number characters from the text text, starting at position start.

Example:

MID("output"; 3; 2)

returns tp.

See also:

LEFT, RIGHT, LEN

Text functions

Personal tools