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.