Hi Guys,

I need your help as i'm at a lost now.
I have set up Excel to retrieve Emails from a specific folder in Outlook.
Only the email body content will be copied to a column in Excel.

The thing is that in the body content i only need a specific text to be copied to a cell.
For example:
"This product has been release - X2345DL . The Item blablabla"


What i need is only the X2345DL in the cell and nothing else.
X2345DL has not specific format, it could be D2345YY and so on.

Any idea how do i do this?

I have an idea of using a column to retrieve the email body content and
copy/filter out the text i need to another column and deleting the column with the email body content when finish.

Appreciate any help! Thanks!!!