Parsing Data from cell returning multiple values

[abbernard10]

Hello all! I need help with parsing out the below and returning the values.

- NON-EDIBLE- RG - - - EA - Brand - - Description - - - Dominance/Flavor/Color - Purchased

Are there formulas to parse out the text in here delimitated by " - " and " - - - " ?

thank you!

 

[MountainFog]

You can use the text to columns feature, choosing delimited, checking both space and other : -, and checking the treat consecutive delimiters as one

 

[abbernard10]

You can use the text to columns feature, choosing delimited, checking both space and other : -, and checking the treat consecutive delimiters as one

Thank you! I'm trying to do it via formula so I can continue to update the source of data without having to use the text-to-columns feature.

 

[MountainFog]

=TEXTSPLIT(SUBSTITUTE(A1," ",""),"-",,1)

 

[Fluff]

@MountainFog the OP is using 2016 (according to their profile) & so does not have Textsplit.