Hello I am using the following:
=MID(B5,SEARCH("[",B5)+1,SEARCH("]",B5)-SEARCH("[",B5)-1)+0
Where cell B5 has the following contents:
=IF(B6="","rdhgxfjhsftjhjh(Text to extract)hujkfjkdjsdt","")
and cell B6 is blank.
I am receiving a #Value error, and am unsure why. My cells are formatted...