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 - WordsMid function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - WordsMid

Syntax:
=WordsMid(Text, StartWord, Count)

Description:
Returns the specified number of words from the Text string starting at word StartWord.

Text : text to consider
StartWord : the word to start taking the substring
Count : number of words to take from the string Text

Example:

The following formula returns the string "fox jumps over"
=WordsMid("the fox jumps over the box",2,3)

litLIB