Data Validation Pull down list How to put a blank in the first candidate in the pull-down. Formulas Date operation How to calculate dates. How to display the day of the week automatically from the date. How to get the last business day of the month. Cell operation Formula to extract only rows with values. Text operation Text comparison. Exact and partial matches. How to reverse text. How to extract only numbers from text. Formula to split text into cells one character at a time. Formulas to remove multiple types of characters from cell text. Formulas to sort text in cells. Formulas to extract text from a cell every specified … Continue reading Tips. Others.(Microsoft Excel)