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

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