Good morning All,
I am trying to create a formula that will extract the words "Mindray BS 380/ BS 400" from the text "[IFCC/ Mindray BS 380/ BS 400]". I am very close, but can't quite finish it. I have so far used the formula =MID(A1,SEARCH("/",A1)+2,SEARCH("]",A1)), which has given me the result Mindray BS 380/ BS 400]. I can't seem to get rid of that outer square bracket.
It has to be a dynamic formula as the text within the square brackets will not always be the same.