MID function

CALC FUNCTIONS

Text Functions

< Previous Section

Next Section >

FUNCTIONS

• ARABIC
• ASC
• BASE
• BAHTTEXT
• CHAR
• CLEAN
• CODE
• CONCATENATE
• DECIMAL
• DOLLAR
• EXACT
• FIND
• FIXED
• JIS
• LEFT
• LEN
• LOWER
• MID
• PROPER
• REPLACE
• REPT
• RIGHT
• ROMAN
• SEARCH
• SUBSTITUTE
• T
• TEXT
• TRIM
• UNICHAR
• UNICODE
• UPPER
• VALUE

< Previous Page

Next Page >

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

• Functions listed alphabetically
• Functions listed by category