Extracting text from a cell
 

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.

Extracting text from a cell
 

=MID(A2,FIND("@",A2)+1,FIND(".",A2)-FIND("@",A2)-1)
--
David Biddulph

"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.

Extracting text from a cell
 

Hi,

Try this

",)

Where B1 contains the email address.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"jmberner" wrote:

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.

Extracting text from a cell
 

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.

Extracting text from a cell
 

Did you try using Find/Replace?

Use *@ in the Find What box,
put nothing in the Replace With box,
and click Replace All

That should do it pretty darn quickly. Just make sure to keep a copy
of your data in case you might need it later.

Note that if the addresses are hyperlinks they will continue to link
to the original address and not just the domain name that remains
after the replace.

On Dec 30, 4:37*pm, jmberner
wrote:
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.