Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Hi, I'm trying to extract the domain name/company name of an email address string. So anything after the "@" and before the "." I've got 400 emails and i've got to catergorise them by company. Your help is much appreciated. -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Hi
Try this: =MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2)-SEARCH("@",A2)-1) Andy. "harpscardiff" wrote in message news:harpscardiff.2954io_1149865806.8229@excelforu m-nospam.com... Hi, I'm trying to extract the domain name/company name of an email address string. So anything after the "@" and before the "." I've got 400 emails and i've got to catergorise them by company. Your help is much appreciated. -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Thanks for the reply. I've tried it, works for some and not for others. theres no obvious pattern? -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Hi
I suppose this could happen if the name before the @ contained a period? Andy. "harpscardiff" wrote in message news:harpscardiff.2955wp_1149867612.5751@excelforu m-nospam.com... Thanks for the reply. I've tried it, works for some and not for others. theres no obvious pattern? -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Try this:
=MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2,SEARCH("@", A2))-SEARCH("@",A2)-1) Andy. "harpscardiff" wrote in message news:harpscardiff.2955wp_1149867612.5751@excelforu m-nospam.com... Thanks for the reply. I've tried it, works for some and not for others. theres no obvious pattern? -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
spot on Andy, worked like a charm. Not compulsory, any chance you can explain whats going on in the formula? I understand the Mid, but the rest, i didn't know it was possible. Cheers. -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting out of a emai address string
Hi
=MID(A2,SEARCH("@",A2)+1,SEARCH(".",A2,SEARCH("@", A2))-SEARCH("@",A2)-1) The MID function uses 'cell', followed by 'start address', followed by 'number of characters to return'. The 'cell' is A2. The 'start address' is 'find the position of @ and add 1'. The 'number of characters' is 'find the position of . after the @' Hope this helps! It may be useful for you to use a very simple example and then select each part of the formula in the formula bar and press F9 to view its results. Andy. "harpscardiff" wrote in message news:harpscardiff.2957ap_1149869404.5548@excelforu m-nospam.com... spot on Andy, worked like a charm. Not compulsory, any chance you can explain whats going on in the formula? I understand the Mid, but the rest, i didn't know it was possible. Cheers. -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=550354 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse File for Mac | Excel Discussion (Misc queries) | |||
Extracting Numeric Data from a Delimited Text String | Excel Worksheet Functions | |||
extracting numbers from string | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Extracting numeric values from string | Excel Worksheet Functions |