Navigation:  Formula Reference > Spreadsheet Formula Functions >

MID

Previous pageReturn to chapter overviewNext page

 

This function returns the requested number of characters from a text string starting at the position you specify.

Syntax

MID(text,start_num,num_chars)

Arguments

This function has these arguments:

Argument

Description

text

Text string containing the characters you want to extract

start_num

Number representing the first character you want to extract in text, with the first character in the text having a value of one (1); if not an integer, the number is truncated

num_chars

Number of characters to return from text; if not an integer, the number is truncated

The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string. The start_num argument has these rules

If start_num is greater than the length of text, this function returns "" (empty text). If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, this function returns the characters up to the end of text.

Data Types

Accepts string data for the text argument, numeric data for the start_num argument, and numeric data for the num_chars argument. Returns string data.

Examples

MID(B17,5,8)

MID(""wind surfing"", 6, 20) gives the result surfing

 

See Also

LEFT

RIGHT