Excel: Formulas to extract nth string with separators

Appreciate any help from the experts here:confused: In a cell, I may need to extract a string divided by separators. Sometimes I need the first, sometimes the second, sometimes the nth. a1: red-orange-yellow-green-blue-indigo-violet formula should return: a2: red a3: orange a4: yellow a5: green a6: blue a7: indigo Help, p:biggrin:r favor!

This question generated 19 answers. To proceed to the answers, click here.

This thread is current as of June 17, 2015.

For more resources for Microsoft Excel