Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Editing Multiple E-Mail Addresses...
I need to edit a list of several thousand email addresses. I require all the
domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
#2
|
|||
|
|||
Hi,
Lets say the email id is in cell A1, use this formula in cell B1 =MID(A1,FIND("@",A1)+1,100) Regards Govind. foofightin wrote: I need to edit a list of several thousand email addresses. I require all the domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
#3
|
|||
|
|||
The formula works but instead of just editing A1, it needs to check A1 to
A1000 odd, and then display all the answers. How does one do this? Thanks "Govind" wrote: Hi, Lets say the email id is in cell A1, use this formula in cell B1 =MID(A1,FIND("@",A1)+1,100) Regards Govind. foofightin wrote: I need to edit a list of several thousand email addresses. I require all the domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
#4
|
|||
|
|||
sorry ignore my last post I just copied and pasted. d'oh
Thanks "foofightin" wrote: The formula works but instead of just editing A1, it needs to check A1 to A1000 odd, and then display all the answers. How does one do this? Thanks "Govind" wrote: Hi, Lets say the email id is in cell A1, use this formula in cell B1 =MID(A1,FIND("@",A1)+1,100) Regards Govind. foofightin wrote: I need to edit a list of several thousand email addresses. I require all the domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
#5
|
|||
|
|||
Hi,
Lets say your data is from A1 to A1000, then enter this formula in B1 and copy it down till B1000 regards Govind. foofightin wrote: The formula works but instead of just editing A1, it needs to check A1 to A1000 odd, and then display all the answers. How does one do this? Thanks "Govind" wrote: Hi, Lets say the email id is in cell A1, use this formula in cell B1 =MID(A1,FIND("@",A1)+1,100) Regards Govind. foofightin wrote: I need to edit a list of several thousand email addresses. I require all the domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
#6
|
|||
|
|||
foo
Insert a column adjacent(right of) the original column. Select the original column. DataText to ColumnsDelimited by @ Delete the column you don't want when complete. Gord Dibben Excel MVP On Thu, 28 Oct 2004 01:33:01 -0700, "foofightin" wrote: I need to edit a list of several thousand email addresses. I require all the domain names need to stay, but all the addresses to be deleted. i.e In my finished format, all that should be left are the domains i.e harrys.com harrys.com elspeths.com To save time is there a function that allows me to do this in 1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge from excel | Excel Discussion (Misc queries) | |||
editing multiple sheets at once | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Editing from Multiple computers? | Excel Discussion (Misc queries) |