Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract sub string
Hi I need to extract the SMTP's from an Exchange export, I've been tring to do it using MID but not having much luck the string looks like this. CCMAIL:secondname, firstname at %X400:c= Country;a= ;p=domain;o=domainLON;s=secondname;g=firstname; and what I want to extract is can't seem to be able to start the extract at SMTP: and then end it at %X400. can anybody help? TIA a newbie :) -- sixbeforedawn ------------------------------------------------------------------------ sixbeforedawn's Profile: http://www.excelforum.com/member.php...o&userid=28297 View this thread: http://www.excelforum.com/showthread...hreadid=478699 |
#2
|
|||
|
|||
Extract sub string
=MID(A1,FIND(":",A1,FIND("%SMTP:",A1)+1)+1,FIND("% ",A1,FIND("%SMTP:",A1)+1)-
FIND(":",A1,FIND("%SMTP:",A1)+1)-1) -- HTH RP (remove nothere from the email address if mailing direct) "sixbeforedawn" wrote in message news:sixbeforedawn.1xecud_1130141128.6472@excelfor um-nospam.com... Hi I need to extract the SMTP's from an Exchange export, I've been tring to do it using MID but not having much luck the string looks like this. CCMAIL:secondname, firstname at %X400:c =Country;a= ;p=domain;o=domainLON;s=secondname;g=firstname; and what I want to extract is can't seem to be able to start the extract at SMTP: and then end it at %X400. can anybody help? TIA a newbie :) -- sixbeforedawn ------------------------------------------------------------------------ sixbeforedawn's Profile: http://www.excelforum.com/member.php...o&userid=28297 View this thread: http://www.excelforum.com/showthread...hreadid=478699 |
#3
|
|||
|
|||
Extract sub string
sorted it ;) =MID(A1, SEARCH("%smtp:",A1)+6, (SEARCH("%X400",A1)-6 - SEARCH("%SMTP:",A1))) Cheers -- sixbeforedawn ------------------------------------------------------------------------ sixbeforedawn's Profile: http://www.excelforum.com/member.php...o&userid=28297 View this thread: http://www.excelforum.com/showthread...hreadid=478699 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXTRACT TEXT FROM TEXT STRING | Excel Worksheet Functions | |||
Extract Part of String | Excel Worksheet Functions | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Extract % from text string | Excel Worksheet Functions | |||
How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions |