Use Text to Columns
Select the cells
Go to Data
Click Text to Columns
Choose Delimited
Select the separator
Click Finish
Use Flash Fill
Type the separated word in the next column
Press Ctrl+E
Use formulas
Use LEFT, RIGHT, and MID
Use FIND or SEARCH to locate spaces or delimiters
Use TEXTSPLIT
Enter a delimiter in the formula
Use Power Query
Load the data into Power Query
Split the column by delimiter
Use Find and Replace
Replace the delimiter with a line break or space
Use CONCAT, TEXTJOIN, or SUBSTITUTE for custom splitting