Find value inside the brackets

**roger81** · 09-09-2009, 12:55 AM

What is the way to find value inside the brackets using excel formulas? For example:

Column A
=======
abc.zyx(hurry)
888 abc(hello world((hurry))
google;defgh(abc(hello world(hurry up)))
klmn;bible(okay)
-2823.gggg; defgh(abc(hello world(no problem!)))

The return value are:
Column B
=======
hurry
hurry
hurry up
okay
no_problem!

Regards,
Roger

**DonkeyOte** · 09-09-2009, 03:27 AM

Perhaps, based on your examples,

Please Login or Register  to view this content.

**roger81** · 09-15-2009, 12:54 AM

Hi,

What is the way to find value inside the brackets using excel formulas? For example:

Column A
=======
abc.zyx(hurry)
888 abc(hello world((hurry))
google;defgh(abc(hello world(hurry up)))
klmn;bible(okay)
-2823.gggg; defgh(abc(hello world(no problem!)))

The return value are:
Column B
=======
hurry
hurry
hurry up
okay
no_problem!

Formula condition is that: cannot use "substitute" and "replace".

Regards,
Roger

**shg** · 09-15-2009, 12:59 AM

Formula condition is that: cannot use "substitute" and "replace".

Why is that?

**roger81** · 09-15-2009, 01:04 AM

Well, this is the rule set that cannot use "substitute" and "replace".

**windknife** · 09-15-2009, 01:32 AM

Try this,

B1

Please Login or Register  to view this content.

Committed with Ctrl+Shift+Enter.
Copied down.

I don't do error handle, you can do it by yourself.

Hope this helps,
WindKnife

**roger81** · 09-15-2009, 02:19 AM

thks! btw it's not working.

**windknife** · 09-15-2009, 02:27 AM

See attached file. Remember to press Ctrl+Shift+Enter after input.

WindKnife

**DonkeyOte** · 09-15-2009, 02:29 AM

This is a dupe thread - given responses I will merge this with your original question (which was answered albeit with SUBSTITUTE & REPLACE (not originally stated)).