Hi,

IF you want to use a non formula based approach, you can use Data Text to
columns as well. Just that you will have to use it twice over - one with a
delimiter of @ and other with a delimiter of .

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jmberner" wrote in message
...
Hello,

I am attempting to extract text from an email address in a cell.
For example
If the cells are the following



I want to write a formula that will extract
Company
AnotherCompany

Any help will be appreciated.