MID function does not show brackets in searched text

I believe Calc’s MID function does not work well when the searched text has brackets.

For example, for a cell with string 12[45]78 ,
MID(cell, 3, 4) should return [4 ,
but returns [45] instead

should return [4

Are you sure? Do you want to talk about it?

Sorry, I ended up writing a silly example. I will close the question. Sorry for that.

For example, for a cell with string 12[45]78 , MID(cell, 3, 4) should return [4 , but returns [45] instead

That sounds like what it should return, from the 3rd character inclusive return the sequence of 4 characters.

If you want just the bracket and the next letter then your friend is =MID(B3,3,2), MID function. Cheers, Al

Sorry, I ended up writing a silly example. I will close the question. Sorry for that.