Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - WordsLeft function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - WordsLeft

Syntax:
=WordsLeft(Text,Number)

Description:
Returns the specified number of words from the left of the text String.

Text : string to consider
Number : number of words to return.

Example:
The following function returns the string "the fox jumps"

=WordsLeft("the fox jumps over the box",3)

litLIB