litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

System - Mid2

Syntax:
= Mid2(Text, Start [, Length])

Description:
Returns a sub string from string Text starting at position Start. If Length is omitted it will return the remainder of the string and otherwise it will return only the number of characters specified by Length.

This function differs from Excel´s mid function in that the Length parameter is optional.

Examples:
=Mid2("abcdefghij",4)
Result: defghij

=Mid2("abcdefghij", 4, 2)
Result: de