Most valuable professional
  • Hot Topics

Excel Formulas to extract nth string with separators

Appreciate any help from the experts here 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, pr 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel