GeertD
Board Regular
- Joined
- Dec 22, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
SPLITONDELIMITER: Split a tekst string based on a delimiter. This is the LAMBDA-fied formula from EMTs 1685 & 1736 on the excelisfun YouTube channel.
Excel Formula:
=LAMBDA(TextString,Delimiter,
FILTERXML("<a><b>"&SUBSTITUTE(TextString,Delimiter,"</b><b>")&"</b></a>","//b")
)| DXLR's LAMBDA.LET Library_v00.07.xlsb | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | The quick brown fox jumps over the lazy dog. | The | ||||
| 2 | quick | |||||
| 3 | brown | |||||
| 4 | fox | |||||
| 5 | jumps | |||||
| 6 | over | |||||
| 7 | the | |||||
| 8 | lazy | |||||
| 9 | dog. | |||||
| 10 | ||||||
Sandbox_Mr.Excel_2 | ||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C1:C9 | C1 | =SplitOnDelimiter(A1," ") |
| Dynamic array formulas. | ||
Upvote
0
