mid

Previous chapterNext chapter Show allShow all    Hide allHide all

The function mid (string, numStart, numLen) returns a string with a defined number (numLen) of characters from the start position (numStart) from the original text string (string).

Syntax: =mid(string,numStart,numLen)

Example Example

Cell A1 = abcdefgh
=mid(A1,2,4) is bcde