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
Tag: Microsoft Excel
Get the Column Letter 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.
Current Date and Time Shortcut Keys Microsoft Excel
Typing the Date Often, when filling out cells in excel, the current date is needed. You could simply type the current date, but there are shortcut keys. . . Using Control and Semicolon for the Current Date . . . a couple of options for shortcut keys. The most basic is simply hit Control and… Continue reading Current Date and Time Shortcut Keys Microsoft Excel