Formula to pull text from between two parentheses

[xBxW]

I have a document I exported from our ERP system. The format of it is not great so I am attempting to clean it up. We have some text that begins in one cell and ends in another cell. For example

column A1
(MUST SEND PART

columnB1
WITH UNIT 2PCS PER)

My question is does anybody have an idea of how I can extract data from a multiple cells between parentheses. I have used a formula like this
=IFERROR(MID(Master!G2,SEARCH("(",Master!G2)+1,SEARCH(")",Master!G2)-SEARCH("(",Master!G2)-1)," ")

To pull anything in a parentheses in a single cell and put it into another cell but was wondering if there was a formula that could look for a beginning parentheses in one cell and an ending parentheses in the next cell and pull that out and put it into its own cell?


Any help or suggestions would be great!!

[modytrane]

If the data is as shown above in A1 and B1
Use this formula in C1:

[protonLeah]

Please Login or Register  to view this content.

[xBxW]

That works great only issue I have is some of the cells contain characters before the ( and your code is including all of the text instead of just the text in the (

Some of my cells could look like this for example. Can the formula be edited to just include in between the parentheses?
column A1
Part # Date (MUST SEND PART

columnB1
WITH UNIT 2PCS PER) Text

[xBxW]

Thanks ProtonLeah that is exactly what I was looking for!

[protonLeah]

You're welcome