LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
link email to drop down list Mike L. Excel Discussion (Misc queries) 3 May 5th 05 10:50 PM
LOOP - Adddress List -to email Paul. Excel Discussion (Misc queries) 0 April 13th 05 09:54 AM
Loop through email address list to send e-mails Paul. Excel Discussion (Misc queries) 1 April 12th 05 12:41 PM
How do I email my contact list to another computer cheree Excel Discussion (Misc queries) 1 February 15th 05 12:54 AM
Using CONCATENATE function to create email addresses from a list Almamba Excel Worksheet Functions 2 January 23rd 05 09:10 PM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ฉ2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"