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.
Neat, thanks so much Jonathan. I had never seen MID function in use either so that was also a learning experience.