=LISTITEMLEFT
The =LISTITEMLEFT() function searches a semicolon separated text list and returns the specified number of leftmost characters from each list entry.
Syntax
Section titled “Syntax”=LISTITEMLEFT(NumberOfCharactersToReturn; SemicolonSeparatedList)Parameters
Section titled “Parameters”-
NumberOfCharactersToReturn – The number of characters to return from the left side of each list entry.
-
SemicolonSeparatedList – The semicolon-separated list of text values to process.
How It Works
Section titled “How It Works”-
Evaluates each item in the provided list.
-
Extracts the specified number of leftmost characters from each list entry.
-
Returns the modified list.
Usage Notes
Section titled “Usage Notes”- Formula functions are case sensitive and must be written in ALL CAPS.
Example
Section titled “Example”=LISTITEMLEFT(4; ListEntry1; Entry2; FindText3; FindText4; LastEntry5)Returns
List; Entr; Find; Find; Last
Keywords
Section titled “Keywords”LISTITEMLEFT, left characters, string manipulation, text extraction, semicolon-separated list, list processing, workflow formulas, formula function