MID Function to find a string within brackets

[Peteor]

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 to Category "General".

I am trying to look at a specific cell (in excel, not VBA) where my "Text to extract" will be part of a formula and within brackets. Does anyone have any ideas?

 

[Aladin Akyurek]

Try to provide examples along with the expected results.

 

[sandy666]

you defined [ but string doesn't contain this so... #VALUE !

 

[Fluff]

Couple of things
1) your text string has brackets (), whilst your formula is looking for braces [].
2) You are trying to add 0 to a text string, which cannot work.

 

[Peteor]

I see. Part of this was my mistake. I edited the formula I listed here to have the braces, and forget to edit the contents of B5. Both B5 and my formula have Braces on the Excel file, and are still returning the #Value error.

Fluff - Thank you! I removed to + 0 and it extracted my string. Problem solved! Thank you everyone.

 

[Fluff]

Glad we could help & thanks for the feedback