Name to Email with exception
Hello,
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", "")
Answers
-
Hello @Desertbird
Thank you for your post! Upon reviewing & testing, I recommend using the formula below:
- =SUBSTITUTE(Supervisor@row, " ", ".") + "@gmail.com"
I had thought that instead of picking out each word, you could use the SUBSTITUTE function to replace all the " " with "."
See my screenshot below.
Hope this helps!
Cheers,
Krissia
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!