Select the cells you want to split.
Go to the Data tab.
Click Text to Columns.
Choose one:
Delimited: to split by a character (comma, space, tab, semicolon, etc.).
Fixed width: to split by column positions.
If using Delimited:
Select the delimiter type (or check multiple delimiters).
If needed, set options like consecutive delimiters and text qualifier.
If using Fixed width:
Drag the vertical separators in the preview to set split points.
Click Next, adjust settings as needed, then click Finish.
For splitting text into separate columns using a formula:
Use TEXTSPLIT (e.g., `=TEXTSPLIT(A1,” “)`) for many Excel 365 versions.