MID()

Characters from text

Returns x number of characters beginning at the specified position in the textual value. If x is greater than the remaining length of text, returns the remainder of the text.

Sample usage

MID("123 Maple Dr", 5, 5) returns  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(text, begin-at, x)

  • text - Any textual type.
  • begin-at - Number that specifies the position, equal to or greater than 1, of the first character in text to return. A non-Number value may be accepted but may produce unexpected results.
  • x -Non-negative number of characters from text to return. A non-Number value may be accepted but may produce unexpected results.

See also

INITIALS()

LEFT()

RIGHT()

SUBSTITUTE()

TRIM()

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
false
false