How do I extract first and last name from an email address in proper form?
![CLBai](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying to do.
Answers
-
Try This
User Name =LEFT(Email@row, FIND("@", Email@row, 1) - 1)
First Name =UPPER(LEFT([User Name]@row, 1)) + MID([User Name]@row, 2, FIND(".", [User Name]@row, 2) - 2)
Last Name =UPPER(MID([User Name]@row, FIND(".", [User Name]@row, 1) + 1, 1)) + RIGHT([User Name]@row, LEN([User Name]@row) - FIND(".", [User Name]@row, 1) - 1)
-
You are a lifesaver, Paul! It worked perfectly. Thank you!
-
@Paul Newcome
How would you configure the above formulas to go from 'Email Address' to 'First Name' and 'Last Name'I've got the 'First Name' formula
Stuck isolating the Last Name and capitalizing the first letter. -
You would use similar logic in a MID function based on a FIND function. The starting point is right after the "." and the ending point is right before the "@".
=UPPER(MID([CBRE Email]@row, FIND(".", [CBRE Email]@row) + 1, 1)) + MID([CBRE Email]@row, FIND(".", [CBRE Email]@row) + 2, FIND("@", [CBRE Email]@row) - (FIND(".", [CBRE Email]@row) + 2))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!