Formula to extract selected text from a cell

[ktyldesley]

Hi all,

I need help w/ a formula that will cut text within parantheses from a text string in one column.

For example, I've got a cell containing the following:

"Labyrinth Stout (Aged in Rye & Bourbon barrels), Unita Brewing Company"

I want cut everything between the parentheses and paste it into a new column.

I'll buy a beer for the best answer!

Thanks,
Kevin

 

[VoG]

Try

=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)

 

[ktyldesley]

That's it, thanks! I owe you a beer.

 

[ktyldesley]

Also need to remove that text from the original cell. Advice? Thanks.

 

[VoG]

Try

=LEFT(A1,FIND("(",A1)-2)&RIGHT(A1,LEN(A1)-FIND(")",A1))

 

[Peter_SSs]

Welcome to the MrExcel board!

In case there is a second beer on offer and my suggestion for the second request is deemed 'better' ..

Excel Workbook
	A	B	C
1	Labyrinth Stout (Aged in Rye & Bourbon barrels), Unita Brewing Company	Aged in Rye & Bourbon barrels	Labyrinth Stout , Unita Brewing Company
Separate Text