Most valuable professional
  • Hot Topics

Excel 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, [email protected] [email protected] [email protected] 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:

This article includes the following tags:

  • Excel
  • Microsoft Excel