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 :
Quick links:
help index

String - WordsMid

=WordsMid(Text, StartWord, Count)

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


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