• Text Functions
  • 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