This content has been marked as final.
Show 2 replies
-
1. Re: Extract first name and last name from email address
Jonathan DrummeyApr 6, 2012 2:14 AM (in response to Xavier P)
Here you go. I used 4 calculations, that could be reduced to two, one to generate the first name and one for hte last name.
The basic process is:
- get the name portion of the email address (everything to the left of the @)
- find out the location of the . in the name portion, if there is any
- use that to get the first name or first initial
- use that to get the last name
See the attached workbook for details.
Jonathan
-
2. Re: Extract first name and last name from email address
Xavier P Apr 6, 2012 9:56 PM (in response to Jonathan Drummey)Neat, thanks so much Jonathan. I had never seen MID function in use either so that was also a learning experience.