Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
I have a large list of email address and would like to group them by
the doamin that they came from I would like to add another collum and and list the doamin names in this collum A collum B ie abc.com does any one have a formula to do this |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
You could use a formula, but I wouldn't.
I'd copy that column of data into another column. Then select the new column Edit|Replace what: *@ with: (leave blank) replace all === But you could use a formula like: =mid(a1,search("@",a1)+1,255) (255 is just a big enough number to grab everything to the right of the @ sign). Ox wrote: I have a large list of email address and would like to group them by the doamin that they came from I would like to add another collum and and list the doamin names in this collum A collum B ie abc.com does any one have a formula to do this -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
Another formula option =REPLACE(A1,1,FIND("@",A1),"") -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145311 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
On Sat, 17 Oct 2009 11:48:06 -0700 (PDT), Ox wrote:
I have a large list of email address and would like to group them by the doamin that they came from I would like to add another collum and and list the doamin names in this collum A collum B ie abc.com does any one have a formula to do this =MID(A1,FIND("@",A1)+1,255) --ron |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
On Oct 17, 9:18*pm, Ron Rosenfeld wrote:
On Sat, 17 Oct 2009 11:48:06 -0700 (PDT), Ox wrote: I have a large list of email address and would like to group them by the doamin that they came from I would like to add another collum and and list the doamin names in this collum A * * * * * * * * collum B ie * * *abc.com does any one have a formula to do this =MID(A1,FIND("@",A1)+1,255) --ron Thank You all for your assistance problem has been solved |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
On Oct 17, 9:08*pm, Dave Peterson wrote:
You could use a formula, but I wouldn't. I'd copy that column of data into another column. Then select the new column Edit|Replace what: **@ with: *(leave blank) replace all === But you could use a formula like: =mid(a1,search("@",a1)+1,255) (255 is just a big enough number to grab everything to the right of the @ sign). Ox wrote: I have a large list of email address and would like to group them by the doamin that they came from I would like to add another collum and and list the doamin names in this collum A * * * * * * * * collum B ie * * *abc.com *does any one have a formula to do this -- Dave Peterson Thank You all for your assistance problem has been solved |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to extract doamin names form email address,s
On Oct 17, 9:17*pm, barry houdini <barry.houdini.
wrote: Another formula option =REPLACE(A1,1,FIND("@",A1),"") -- barry houdini ------------------------------------------------------------------------ barry houdini's Profile:http://www.thecodecage.com/forumz/member.php?userid=72 View this thread:http://www.thecodecage.com/forumz/sh...d.php?t=145311 Thank You all for your assistance problem has been solved |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract email(s) from address field | Excel Discussion (Misc queries) | |||
Extract domain names from email IDs | Excel Worksheet Functions | |||
How to extract email address in hyperlink | Excel Worksheet Functions | |||
How to extract email address and place into a new column | Excel Worksheet Functions | |||
add email address to a list of names | Excel Discussion (Misc queries) |