Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting text from a cell | Excel Worksheet Functions | |||
Extracting text from a cell | Excel Discussion (Misc queries) | |||
EXTRACTING NUMBERS FROM A TEXT CELL | New Users to Excel | |||
Extracting text from a cell entry | Excel Discussion (Misc queries) | |||
extracting text data in a cell | Excel Worksheet Functions |