Seperate Name
Below is a formula I found here in the Community. While the first name worked, the last name didn't. Well, it did but the comma is appearing. I also noticed that if the hyphenated name is lenghty, it only returns the first part of the last name, the dash and first letter.
I also have names that are pretty lenghty that includes preferred names in parenthesis for example:
Neely (Jenn), Jennifer Genelle
Should be Jennifer Neely.
I need just a first and last name yielded. Any help will be appreciated.
Name | First | Last |
---|---|---|
Doe-Smith, Jasmine Marie | Jasmne Marie | Doe-Smith, |
=RIGHT(NAME@row, LEN(NAME@row) - FIND(" ", NAME@row)) | =LEFT(NAME@row, FIND(" ", NAME@row) - 1) |
Best Answer
-
You only have it looking for the space and not the comma. Try.
=Left(Name@row,Find(", ",Name@row)-2)
How ever due to the nature of how the names are created. The only consistent thing that can be pulled is the first name.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
You only have it looking for the space and not the comma. Try.
=Left(Name@row,Find(", ",Name@row)-2)
How ever due to the nature of how the names are created. The only consistent thing that can be pulled is the first name.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Thanks for your help and feedback!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!