split email id list into 1 extra list with everything after "@"

split email id list into 1 extra list with everything after "@"

Post by JE McGimps » Fri, 19 Jan 2007 19:28:58

One way:

B1: =MID(A1,FIND("@",A1)+1,32000)
C1: ="www."&B1

In article < XXXX@XXXXX.COM >,

> in one column and everything behind the in another column. >> >> Example >> >> >> Full email ID = XXXX@XXXXX.COM ; >> >> 1 column = XXXX@XXXXX.COM ; >> >> Next column = xyz.co.uk; >> >> It would also be helpful to add another column which added the ww> > > > ie new column = www. xyz.co.uk> > > > Thanks

1. need function: split string by list of strings and return delimiters and extra text

2. AnuraSoftware Enable Incoming Email for Custom List, Task List, Issue List ...


Anura Email Enabled List extends the ability of receiving incoming emails to all types of SharePoint list. Microsoft SharePoint 2007 only allows Document Libraries, Announcements list, Calendar list, Discussion board and Blog list to receive incoming emails. Anura Software helps you to remove this limitation and extends this ability to all your selected lists, such as task list, issue tracking list, and any custom lists. Anura Email Enabled List is a complete email collaboration solution for you organization by saving email metadata including email headers, body and attachments in SharePoint list.

Anura Email Enabled List also contains outgoing email features which can send auto-reply confirmation and notification to email senders. This is useful for building a SharePoint based issue tracking system.

Regarding discussion list

Hi satish,

I have seen your comment in that you have mentioned that you can able to send an email to discussion list.

I just want to know that if i am sending an incident from email it wants to come in the discussion list how can i do this if you have any suggesstion or link please send me.


Previous Posts In This Thread:

Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating a WPF Custom Control

3. How to merge multiple Contact Lists into one or Delete extra list

4. Value lists that show an extra field only list unique values

5. Generic List - Split list

6. biblatex do not list crossreferences automatically when I split the list through categorization

7. Regular Expressions to Split Lists Into Sub-Lists

8. natbib, list of citations, but split out into an author list

9. [PATCH 1/2] Split list.h and move rcu-protected lists into rculist.h

10. Split long list of list items

11. easiest way to split a list into evenly divisble smaller lists, and assign them to variables?

12. [PATCH 1/2] page-allocator: Split per-cpu list into one-list-per-migrate-type

13. [PATCH 1/2] Split list.h and move rcu-protected lists into rculist.h

14. [PATCH 3/11] Split the per-cpu lists into RCLM_TYPES lists

15. Splitting a List using difference list