Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a specific email from cells and putting info in new row
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pulling a specific email from cells and putting info in new row
Hi Chris,
Am Thu, 7 Mar 2013 11:27:29 -0800 (PST) schrieb : XXXXX | Xxxxxxxxx" Step1 select the column = Data = TextToColumns = Delimited" = Delimiter = Other = 0 = Column with "Unsubscribe..." skip (do not import column) Step2 select the column = Data = TextToColumns = Delimited" = Delimiter = Other = "" = Column with " XXX..." skip (do not import column) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting specific info from cells | Excel Discussion (Misc queries) | |||
need some help pulling columns from one table and putting into ano | Excel Discussion (Misc queries) | |||
Pulling file names & path from folder and putting them in cells | Excel Programming | |||
Pulling info 2 cells and putting it in one | Excel Worksheet Functions | |||
Pulling parts of information from one cell and putting in another | Excel Discussion (Misc queries) |