New Tip: Searching For Words
I posted a new tip today, a VBA function that answers the question: Is A Particular Word Contained In A Text String?
I wrote this function to solve a practical problem. At my other blog, I've been posting lists of songs that contain a particular word. I have my music list in an Excel workbook, but none of the built-in tools are able to let me search for a particular word without getting false hits. For example, if I search for the word friend, I'll also get song titles that contains friends, friendly, friendship, and so on.
The ExactWordInString function, listed in the tip, solves this problem and lets me identify only the songs that contains the exact word I specify.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.