You will have to parse out the string and apply all your special rules.

--
Regards,
Tom Ogilvy

"jasonsweeney " wrote in
message ...
Additionally, I need numbers and punctuation to be counted as separate
words.

e.g.:
[12345] typed into the textbox must equal 5 "words".

[See Spot Sit.] = 6 words (period equals "word")

[I said to the man "you must go."] = 18 words (each quotation mark = 1
word.


---
Message posted from http://www.ExcelForum.com/