Extracting Information From Email Reciept

[djfatboyfats]

Good afternoon,

I'm looking to find a way to extract an email address an a reference number from an email receipt that i have extracted to excel. The problem is when I paste the information its pastes onto multiple rows and not a single row.

I'm using this formula to extract the email address and can do something else to get the ref number out however the results are on multiple lines which is not good to me. Please have a look at the example so you can see what i'm trying to achieve.

Please Login or Register  to view this content.

I have attached a document to show you how the data extractS on (EXAMPLE TAB) The information I want to extract is the stuff in Red. I then want the results to look like the Results Tab in the example.

Thanks in advance

DJ

[ChemistB]

Would this work for you?
On another sheet in the workbook, enter this ARRAY formula copied down

=IFERROR(INDEX(Example!$A$1:$A$1000,SMALL(IF(ISNUMBER(SEARCH("@",Example!$A$1:$A$1000)),ROW($A$1:$A$1000)),ROWS($A$1:$A1))),"")

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[djfatboyfats]

That's good, thanks for that but how do I then get the reference number to sit next to the email address like it does in the Results tab?

[ChemistB]

I don't see any reference numbers on your example. ?