Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a game-changer if you want to quickly extract specific columns or rows from your data without nesting several functions in your formula ...

For example, if I have a URL in one column, can I extract the date from that URL and put it in the date column so I don't have to add the date manually? Why yes, you can. Here it is in action in a ...