Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Pulling a specific email from cells and putting info in new row

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.

I do alot of these and it would help the entire operation a whole lot
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Pulling a specific email from cells and putting info in new row

Update:

I found something that works, so I can get the cells down to just this

XXXXX | Xxxxxxxxx"

Is there a code that will Remove everything but the email? Or at least something to get it as close to just the email as possible?
Reply
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
Extracting specific info from cells johnhaskell Excel Discussion (Misc queries) 7 June 16th 12 01:49 AM
need some help pulling columns from one table and putting into ano need-some-help![_2_] Excel Discussion (Misc queries) 1 February 12th 09 03:26 AM
Pulling file names & path from folder and putting them in cells Ren Excel Programming 5 March 4th 08 10:38 AM
Pulling info 2 cells and putting it in one Ian Excel Worksheet Functions 3 September 14th 07 07:24 PM
Pulling parts of information from one cell and putting in another Mcobra41 Excel Discussion (Misc queries) 3 March 4th 05 08:01 PM


All times are GMT +1. The time now is 11:14 AM.

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

About Us

"It's about Microsoft Excel"