How to extract multiple instances of a pattern (between "-"'s) within a single cell

[IeuanCilgwri]

The above is an extract of a very large value in a single cell, I would to extract into a cell ALL the instances that occur between the "-" - so the above would return LFN,LFN,LEM,LEL - thank you!

 

[Peter Bartholomew]

With 365 you could try things like

= LET(
    splitOnHyphen, TEXTSPLIT(value,,"-"),
    twoColumns,    WRAPROWS(splitOnHyphen,2),
    codeInstances, TAKE(twoColumns,, 1),
    TEXTJOIN(",",,codeInstances)
  )

which picks up on the alternating pattern of hyphens.

There are some add-ins that implement RegEx, one of which is Charles Williams's FastExcel (c)

= Rgx.MID(value,"\-\w{3}\-",0)

 

[bosco_yip]

Try,

In B, enter formula:

=TEXTJOIN(",",,FILTERXML("<a><b>"&SUBSTITUTE("@"&A2,"-","</b><b>")&"</b></a>","//b[string-length(.)=3]"))