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
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives