Forum Discussion
Split a string by delimited characters and choose nth position in string
Looking for an excel formula that will take a string similar to this Instance >> Chain >> TimeZone >> State >> City >> Number >> Number2 And be able to output only the first "Number" occurren...
Let's say the string is in A2.
In another cell, for example B2:
=--INDEX(TEXTSPLIT(A2, " >> "), 6)
This can be filled down.