Hi,

I was wondering if someone could help me. My boss has given me a pst file which has been exported to a excel file. He wants me to extract out the email address from the message. All the messages are email address that don't exist anymore.

So basically I just want the email left minus the < > signs. Does anyone know a formula or macro that will search for anything inside the cell and return me everything just left and right of the @ sign.

Many thanks