How to Separate First Name, Last Name, and Title in Excel

what is the best way to seperate first name, last name and title (if they are all in the same cell)

· Sorted by Oldest

Clay
APP
·
·
You can use an AI column with ChatGPT Generate Text to normalize names in your table. Add a new column (click "Add column" > "Use AI"), then use a pre-built template to extract first name, last name, and title from your combined data. Alternatively, create a formula column to split the text using merge columns functionality.
Sources: Table columns | Documentation | Clay University Manage cell data | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.

Clay
APP
·
·
You can use an AI column with ChatGPT Generate Text to normalize names in your table. Add a new column (click "Add column" > "Use AI"), then use a pre-built template to extract first name, last name, and title from your combined data. Alternatively, create a formula column to split the text using merge columns functionality.
Sources: Table columns | Documentation | Clay University Manage cell data | Documentation | Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.