The easiest way to split text in a cell in Excel into multiple columns based on spaces is to use the **TEXTSPLIT** function.

This function uses the following basic syntax:

=TEXTSPLIT(A2, " ")

This particular formula splits the text in cell **A2** into multiple columns based on where the spaces occur in the cell.

The following example shows how to use this formula in practice.

**Example: How to Split Text by Space in Excel**

Suppose we have the following column in Excel that contains information about various basketball players:

Suppose we would like to split the text in each cell into multiple columns based on where the spaces occur in the text.

We can type the following formula into cell **B2** to do so:

=TEXTSPLIT(A2, " ")

We could then click and drag this formula down to each remaining cell in column B:

The **TEXTSPLIT** function splits the text of each cell in column A into multiple columns based on where the space occurs.

Note that if you’d like to split the text by a different delimiter, simply specify that delimiter in the second argument of the **TEXTSPLIT** function.

For example, you could use **=TEXTSPLIT(A2, “,”)** to instead split based the text based on where commas occur.

**Note**: You can find the complete documentation for the **TEXTSPLIT** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Split Word into Individual Letters

Excel: How to Split Addresses into Multiple Cells

Excel: How to Split String by Specific Length