Skip to main content
Version: Streamsheets 3.0

MID

Return the given amount of characters starting at the given index from a string.

Syntax

=MID(Text, Index, Count)

Arguments

NameTypeDescription
TextStringText to extract string from.
IndexNumberIndex to start extracting from.
CountNumberNumber of characters to extract.

Return

TypeDescription
StringThe text that that is extracted from the given text using the arguments.

Examples

FormulaResultComment
=MID("SampleText", 3, 2)
"pl"