New Text Splitting Functions in Excel

Microsoft Excel Tips and Tricks

With Excel’s Choose function, you can create a list of items, then select which of those items you want the function to return. For example, if you have a list of ice cream flavors that’s chocolate, vanilla, and coffee and specify item #2, the function will return “vanilla”.

Credit Experts Exchange