On Thursday, March 7, 2013 12:06:51 PM UTC-7, Claus Busch wrote:
Hi,



Am Thu, 7 Mar 2013 10:58:40 -0800 (PST) schrieb

:



So I do alot of work with excel spreadsheets, and cant figure out how to do this. basically I have a cell that will have an email chain with response. So the cell will have multiple email addresses in it when i export all of the email responses into a CSV file from outlook, but I just want to extract the ones at the very end of the cell that have the "unsubscribe" in front of them so it looks like this below.



?subject=Unsubscribe%TH "



would it be possible to do a search and just pull the last part after "unsubscribe" and put it into the cell next to it? Just a generic email pull wont work because i just need the last one, otherwise it will pull our email address and other ones I dont need.



your string in A1. Then try:

=SUBSTITUTE(MID(A1,FIND("Unsubscribe",A1)+12,99)," ",)





Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Tried this with the cell being A1 and it just returned with an error :/