Category: Long and Short Tutorial Series

The File I used to make these videos is available for download: These videos are designed specifically to teach how to create a function that returns TRUE if a string of text you wish to search for is contained within a longer, more complex piece of text in Microsoft Excel. This can be used along-side… Continue reading Searching for a Text String Within Another Text String In Microsoft Excel

There are times when it is helpful to know the column letter in which a function or formula is executed. This is an in-depth description and demonstration of how I use the ADDRESS, COLUMN and SUBSTITUTE functions to make a handy, easy-to-use formula designed to get the column letter.