How do you extract bracketed text from a cell (excluding the brackets) ?

**purplerainn** · 10-08-2020, 09:40 AM

Hey everyone,

For example, if I have this in a cell:

> John Robertson (john.robertsonAThotmaildotcom), Jim John (jimjohnATgmaildotcom)

Is there something I can do that spits out just the two emails within the brackets, side by side in separate columns?

**KOKOSEK** · 10-08-2020, 10:00 AM

	A	B	C
1	John Robertson (john.robertsonAThotmaildotcom), Jim John (jimjohnATgmaildotcom)	john.robertsonAThotmaildotcom	jimjohnATgmaildotcom

B1:

Formula:

Please Login or Register  to view this content.

and drag it right into C1

How do you extract bracketed text from a cell (excluding the brackets) ?

LinkBack

Thread Tools

Rate This Thread

Display

How do you extract bracketed text from a cell (excluding the brackets) ?

Re: How do you extract bracketed text from a cell (excluding the brackets) ?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to Extract Number in Brackets from Cell

[SOLVED] Extract all text in brackets into new row

Extract text from second set of brackets

[SOLVED] Macro that will turn any text (bracketed) to red

[SOLVED] How to extract text between brackets/parentheses in Excel?

Extract multiple occurrences of text within brackets from a cell

Formula to extract data within Brackets from text string

Bookmarks

Bookmarks

Posting Permissions