Split Bracketed Text Across Columns

[NorthbyNorthwest]

Hi, everyone. Hope someone can help. I have a column in which each cell contains one, two, three or more bracketed sets of numbers. Example: [2784][7115][3412]. No spaces between the brackets. I need to break these bracketed numbers out into individual column cells, preferably with brackets removed. But brackets remaining is OK too. I have been working with new TEXTSPLIT" function without success. Does anyone know of a formula which would accomplish this?

 

[Dave Patton]

I have not used these functions before.
The following may help.

TextBefore.xlsm
	A	B	C	D	E
1
2		[2784][7115][3412]	2784	7115	3412
3		[2784][7115]	2784	7115
4
1b

Cell Formulas
Range	Formula
C2:F2,C3:E3	C2	=IFERROR(TEXTAFTER(TEXTSPLIT(B2,"]"),"["),"")
Dynamic array formulas.

 

[Dave Patton]

TextBefore.xlsm
	A	B	C	D	E	F
1
2		[2784][7115][3412]	2784	7115	3412
3		[2784][7115]	2784	7115
4		[2784][7115][3412]	2784	7115	3412
5		[3412]	3412
6		[2784][7115][3412][1234]	2784	7115	3412	1234
7		[2784][7115][3412][]	2784	7115	3412
8
1b

Cell Formulas
Range	Formula
C2:E2,C6:F7,C5,C4:E4,C3:D3	C2	=TEXTAFTER(TEXTSPLIT(B2,"]",0,1),"[",,1,1)
Dynamic array formulas.

 

[NorthbyNorthwest]

I too am new to these array formulas. Thank you so much for answering, Dave.

 

[JvdV]

TextBefore.xlsm
	A	B	C	D	E	F
1
2		[2784][7115][3412]	2784	7115	3412
3		[2784][7115]	2784	7115
4		[2784][7115][3412]	2784	7115	3412
5		[3412]	3412
6		[2784][7115][3412][1234]	2784	7115	3412	1234
7		[2784][7115][3412][]	2784	7115	3412
8
1b

Cell Formulas
Range	Formula
C2:E2,C6:F7,C5,C4:E4,C3:D3	C2	=TEXTAFTER(TEXTSPLIT(B2,"]",0,1),"[",,1,1)
Dynamic array formulas.

Have a go with:

=DROP(IFERROR(--REDUCE(0,B2:B7,LAMBDA(a,b,VSTACK(a,TEXTSPLIT(b,{"[","]"},,1)))),""),1)

TEXTSPLIT() take an array of delimiters. Also, it's quite unfortunate that it won't spill over different lengths when applied to a range (would just return the 1st element). Therefor we can apply the above trick with REDUCE(). The double unary is applied to return numeric data. Remove these if need be.

 

[Fluff]

Another option

=TEXTSPLIT(B2,{"[","]"},,1)