Forum Discussion

Brass Contributor

Jul 03, 2022

Solved

Get MULTIPLE values between characters

Hi! I use a formula to get the value between [] For example: SELECTEDVALUE(Division[SubDivision Name], "Multiple Divisions") I use this formula, which works great: =MID(LEFT(B2;FI...

excel

Formulas and Functions

Patrick2788

Jul 03, 2022

Celia9

A variant:

=LET(b,B2,arr,MID(b,SEQUENCE(LEN(b)),1),position,SEQUENCE(ROWS(arr)),LBracket,FILTER(position,arr="[")+1,Rbracket,FILTER(position,arr="]"),string,MID(b,LBracket,Rbracket-LBracket),TRANSPOSE(string))

Patrick2788

Silver Contributor

Jul 03, 2022

Celia9

A variant:

=LET(b,B2,arr,MID(b,SEQUENCE(LEN(b)),1),position,SEQUENCE(ROWS(arr)),LBracket,FILTER(position,arr="[")+1,Rbracket,FILTER(position,arr="]"),string,MID(b,LBracket,Rbracket-LBracket),TRANSPOSE(string))