Forum Discussion

Occasional Reader

Jul 10, 2026

Text split

I have this informatie in a cel: WIJNVEEN 15693 | 88/38 | 31-12-2024 | [WIJNVEEN|15693] I need the two components at the end, the parts between [ and ] So one cel is "WIJNVEEN" and the second cel...

excel

Formulas and Functions

m_tarler

Silver Contributor

Jul 10, 2026

You can do both cells with 1 formula:

=TEXTSPLIT(TEXTBEFORE(TEXTAFTER(A1,"["),"]"),"|")

Or split into 2 formula:

=TEXTBEFORE(TEXTAFTER(A1,"["),"|")
=TAKE(TEXTSPLIT(TEXTBEFORE(A1,"]"),"|"),,-1)

Or you can use RegEx but I'll leave that to someone better with RegEx than me.

I did assume there was only and always 1 case of [ ] but didn't assume it was always at the very end of the cell. You may also want to add the IfNotFound optional parameters if that is reasonably possible.

If you want to use an input array like A1:A100 then you will need to tweak it or use LAMBDA to make them work