Name to Email with exception
I have a function that turns a cell with a name into an email address for supervisors. However, some supervisors are in training and have an abbreviation at the end of their name, is there a way to come to the same email result? The cell text would be
First Last (T1)
(number after T is different for each person)
=IFERROR(LEFT(Supervisor@row, FIND(" ", Supervisor@row) - 1) + "." + RIGHT(Supervisor@row, (LEN(Supervisor@row) - FIND(" ", Supervisor@row))) + "@gmail.com", "")
Help Article Resources
Check out the Formula Handbook template!