Appreciate any help from the experts here![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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
r favor!
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