I'm trying to extract some text in a [] the data looks like this:

Basically I need the middle information, what I've tried was using split but I don't need more columns and also tried to use =REGEXEXTRACT() but did't work well some formulas suggestion please!

CodePudding user response：

regex \[(. ?)\] will capture text between [ and ]

=REGEXEXTRACT(A2; "\[(. ?)\]")