Restructure name

Hello,

What is the easiest way to turn First Last into Last, First?


The below formula worked in Excel, but is there an alternative to "Search" in Smartsheets?

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2))&", "&LEFT(A2,SEARCH(" ",A2)-1)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!