The simplest way to achieve that is to: The drop-down list is ready. For combo-box you should use VBA, I believe. But you may also …
Continue ReadingMS Excel: Conversions and other
Convert Date/Time Format Cell to Date only The following formula will help you converting date/time format cell to date only in Excel. Select a blank …
Continue ReadingMS Excel: find a string in a cell
You have an excel file. In one column there are not specific answers or numbers. There are texts. And you need to know which of …
Continue Reading