Skip to main content
MID
Updated over 2 weeks ago

Extracts a portion of text starting from a specified position with a given length

Description

The MID() function is used to extract a subtext from text, starting from a specified character position and of a specified length. This function is useful for text manipulation and data extraction.

Syntax

MID(text, start, [length])

Output

text

Variables

  1. text: The input text from which you want to extract subtext.

  2. start: The starting position within the text. The start position begins at 1.

  3. length: (Optional) The length of the subtext to be extracted.

Example

MID(`Product Code`,4)

ID

Product Code

MID

1

ELE12345

12,345

2

CLO67890

67,890

3

FOO45678

45,678

Did this answer your question?