## Examples

`MID("123 Maple Dr", 5, 5)`

: *Maple*

`MID("123 Maple Dr", 5, 0)`

returns blank.

### Fractional Component of Decimal Value

The integer component of a *Decimal* value in the *Result* column:

`NUMBER(`

MID(

TEXT([Result]),

(FIND(".", TEXT([Result])) + 1),

LEN(TEXT([Result]))

)

)

`TEXT([Result])`

converts the*Decimal*value to a*Text*value. The textual functions used in this example interpret non-textual values differently. Using*TEXT()*ensures the*Result*column value is interpreted the same by each function.`(FIND(".", ...) + 1)`

locates the beginning of the fractional component as the position immediately after the decimal point in the value.`MID(..., ..., LEN(...))`

extracts the fractional part using a*how-many*value guaranteed to cover the entire fractional component.`NUMBER(...)`

converts the extracted text to a*Number*.

See also: *FIND()*, *LEN()*, *NUMBER()*, *TEXT()*

## Syntax

**MID(** *some-text* **,** *begin-at* **,** *how-many* **)**

## Arguments

*some-text*(any textual type)*begin-at*(*Number*) : The position, equal to or greater than 1, of the first character in*some-text*to return. A non-*Number*value may be accepted but may produce unexpected results.*how-many*(*Number*) : The non-negative number of characters from*some-text*to return. A non-*Number*value may be accepted but may produce unexpected results.

## Return Value

*Text*: The *how-many* characters beginning at position *begin-at* from *some-text*. If *how-many* is greater than the remaining length of *some-text*, the remainder of *some-text* is returned.