Chemist, ask and ye shall receive...
Example Usage:
=WORD(A1,5,2," ")
A1 = str = original phrase/sentence
5 = startNum = starting word # based on delimeter
2 = wordCount = number of words to return based on delimiter
" " = delim = character of delimiter
Updated (7/15/09): Added Dim for variable i; Changed Dim for "updtStr" to "updStr" as it's used in the code; Made last two arguments optional and set defaults if they were not included in the function. (I really need to start using Option Explicit!!!)
Bookmarks