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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!