Hi All,
I have extracted few emails from my outlook. Now I want to extract only emails from the body of the column. Is there any formula or function to do so. Kindly check the attachment.
Hi All,
I have extracted few emails from my outlook. Now I want to extract only emails from the body of the column. Is there any formula or function to do so. Kindly check the attachment.
=MID(A2,FIND(":",A2)+10,(FIND("Technical",A2)-12)-FIND(":",A2)-2)
If you are happy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Or this
=LEFT(TRIM(REPLACE(A2,1,FIND(":",A2),"")),FIND("T",TRIM(REPLACE(A2,1,FIND(":",A2),"")))-5)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
In most of the cases. The above formulas is not returning the email. Please check the attachment
This is why it is important to provide accurate requirements. The added part of the data added is very different than the one you provided earlier.
The logic should be like this. First it should find the "@" then before and after the @, it should return all the character till spaces.
Last edited by sathishkm; 01-28-2014 at 11:21 AM.
Is there any way from outlook to show the bounced emails?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks