[]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

MID

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