last, first to first last
I want to flip a column which will be last, first names and return first last.
So Doe, John becomes John Doe
I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is not helpful.
Last Name Formula:
=LEFT(NAME31, FIND(",", NAME31) - 1)
First Name Formula:
=RIGHT(NAME34, LEN(NAME34) - FIND(",", NAME34))
Tags:
Answers
-
You can concatenate cells in Smartsheet with the + symbol (similar to the & in Excel, if you are familiar how to use that). So all you have to do is add them together with:
=RIGHT(NAME@row, LEN(NAME@row) - FIND(",", NAME@row) - 1) + " " + LEFT(NAME@row, FIND(",", NAME@row) - 1)
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!