Hi,
I'm trying to extract the number between the two "[]" in cell's text

tried to use a mix of MID and INSTR but it doesn't work for me
Can someone please help me with the code for it?
Thank you!