| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
split email id list into 1 extra list with everything after "@"
I have a column of email addresses in an excel spreadie.
I want to split those email addresses so that I have the full email address in one column and everything behind the @ in another column. Example Full email ID = ; 1 column = ; Next column = xyz.co.uk; It would also be helpful to add another column which added the www ie new column = www. xyz.co.uk Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
split email id list into 1 extra list with everything after "@"
Put this formula in the cell next to the email address.
Assuming your first itme is in cell ref A1; ="www."&RIGHT(A1,(LEN(A1)-(FIND("@",A1)))) You can copy and paste-special values once you have filled in the details, to get rid of the formula. "Rob" wrote: I have a column of email addresses in an excel spreadie. I want to split those email addresses so that I have the full email address in one column and everything behind the @ in another column. Example Full email ID = ; 1 column = ; Next column = xyz.co.uk; It would also be helpful to add another column which added the www ie new column = www. xyz.co.uk Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
split email id list into 1 extra list with everything after "@"
One way:
B1: =MID(A1,FIND("@",A1)+1,32000) C1: ="www."&B1 In article , Rob wrote: I have a column of email addresses in an excel spreadie. I want to split those email addresses so that I have the full email address in one column and everything behind the @ in another column. Example Full email ID = ; 1 column = ; Next column = xyz.co.uk; It would also be helpful to add another column which added the www ie new column = www. xyz.co.uk Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
split email id list into 1 extra list with everything after "@
Thanks very much for this! Can you also help me on this one - I want to
split 1000+ email ID's copied into 1 cell, into separate cells within a column.. Thanks - Rob "Cin" wrote: Put this formula in the cell next to the email address. Assuming your first itme is in cell ref A1; ="www."&RIGHT(A1,(LEN(A1)-(FIND("@",A1)))) You can copy and paste-special values once you have filled in the details, to get rid of the formula. "Rob" wrote: I have a column of email addresses in an excel spreadie. I want to split those email addresses so that I have the full email address in one column and everything behind the @ in another column. Example Full email ID = ; 1 column = ; Next column = xyz.co.uk; It would also be helpful to add another column which added the www ie new column = www. xyz.co.uk Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
split email id list into 1 extra list with everything after "@
Thanks very much for this! Can you also help me on this one - I want to
split 1000+ email ID's copied into 1 cell, into separate cells within a column.. Thanks - Rob "JE McGimpsey" wrote: One way: B1: =MID(A1,FIND("@",A1)+1,32000) C1: ="www."&B1 In article , Rob wrote: I have a column of email addresses in an excel spreadie. I want to split those email addresses so that I have the full email address in one column and everything behind the รขฌล@รขฌย in another column. Example Full email ID = ; 1 column = ; Next column = xyz.co.uk; It would also be helpful to add another column which added the รขฌลwwwรขฌย ie new column = www. xyz.co.uk Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link email to drop down list | Excel Discussion (Misc queries) | |||
| LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
| Loop through email address list to send e-mails | Excel Discussion (Misc queries) | |||
| How do I email my contact list to another computer | Excel Discussion (Misc queries) | |||
| Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Linear Mode
