How do I split first name last name into two cells?
I have one cell with first name last name (e.g. Judy Campf). I want to pull out "first name" and "last name" into their own columns.
This formula worked for the first name.
=LEFT([Active Teachers]@row, FIND(" ", [Active Teachers]@row) - 1)
I can't get a similar formula to work for the last name.
Thanks in advance!
Judy
Best Answer
-
Hi @Judith Campf,
Try this:
=RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(CHAR(10), SUBSTITUTE([Full Name]@row, " ", CHAR(10), LEN([Full Name]@row) - LEN(SUBSTITUTE([Full Name]@row, "-", "")))))
Answers
-
Hi @Judith Campf,
Try this:
=RIGHT([Full Name]@row, LEN([Full Name]@row) - FIND(CHAR(10), SUBSTITUTE([Full Name]@row, " ", CHAR(10), LEN([Full Name]@row) - LEN(SUBSTITUTE([Full Name]@row, "-", "")))))
-
That did it! My sincerest thanks.
Judy
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives