Split(’').Length

Returns the number of words in this instance. Please note that in the following cases, spaces, commas, semicolons, parentheses, and dashes are considered word separators. You can adjust this for your needs.