How do I extract first and last name from an email address in proper form?
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
- 63.7K Get Help
- 406 Global Discussions
- 217 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!