Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

MID

Description: Returns a specific number of characters from a text string, starting at the position you specify.

Syntax: MID(Text, Start_num, Num_char)

• Text is the text string containing the characters you want to extract.

• Start_num is the position of the first character you want to extract in Text. The first character in Text has Start_num 1, and so on.

• Num_char specifies the number of characters you want MID to return from Text.

Remarks:

• If Start_num is greater than the length of Text, MID returns "" (empty text).

• If Start_num is less than the length of Text, but Start_num plus Num_char exceeds the length of Text, MID returns the characters up to the end of Text.

• Start_num must be greater than 1.

• Num_char must not be negative.

Example:

• MID("Fluid Flow", 1, 5) = Fluid [five characters from the string, starting at the first character]

• MID("Fluid Flow", 7, 20) = Flow [twenty characters from the string, starting at the seventh character]