• ANSI Character Functions
• CLNTDIR Function
• CLNTNAME Function
• CURRENCY Function
• DOCPATH Function
• IN Function
• LEFT Function
• LENGTH Function
• LOWER Function
• LTRIM Function
• MID Function
• MKSTR Function
• PRGDIR Function
• RIGHT Function
• SCANSTR Function
• SPACE Function
• STR Function
• SUBSTR Function
• Text Functions
• TITLE Function
• TOKEN Function
• TOKENSUB Function
• TRIM Function
• TRIMRTF Function
• UPPER Function
• XRND Function
• XWKS Function

MID Function

The MID function selects a portion of the string to display beginning at value 1 characters from the left of the string for value 2 characters into the string. Value 2 is optional. If value 2 is not supplied, the function returns all remaining characters. This function is only applicable for alphanumeric cells.

Syntax

MID(expression,value1,<value2>)

Example

MID("Prince Edward Island",8,6)

Where 8 characters into the string is the E of Edward and 6 characters from the E of Edward is the last D of Edward. Therefore the cell displays Edward.

Related Topics

• Text Functions