Excel: (Urgent Request) Extract first name and last name from Email ID

Dear all, I have a simple requirement. Suppose i have few mail ID's as below, aaaa.bbbbbb@xx.com ccccccc.dd@xx.com eeeeeeeeeeee.f@xx.com I want the vba code and extract firstname and last name from the these mail ID's Note: From beginning till special character "." are my first names. And from "." till special character "@" are my second names. Please provide me the code. Thanks Madvesh

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of November 16, 2014.

For more resources for Microsoft Excel