How to Split a Cell Vertically in Excel (With Example)


You can use the following formula in Excel to split a cell vertically into multiple cells:

=TEXTSPLIT(A2,, ", ")

This particular formula splits the values in cell A2 vertically into multiple cells, using a comma as the delimiter to determine where to split the values.

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

Example: How to Split a Cell Vertically in Excel

Suppose we have the following list of basketball team names in cell A2 in Excel:

Suppose we would like to split the team names in this cell vertically into multiple cells.

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

=TEXTSPLIT(A2,, ", ")

The following screenshot shows how to use this formula in practice:

Excel split cell vertically

Column C now contains each of the individual team names from cell A2 split into multiple cells vertically.

How This Formula Works

The TEXTSPLIT function in Excel uses the following syntax:

TEXTSPLIT(text, col_delimiter, row_delimiter, …)

where:

  • text_col: The text you want to split
  • col_delimiter: The delimiter to split text across columns
  • row_delimiter: The delimiter to split text across rows

By using the formula =TEXTSPLIT(A2,, “, “) we tell Excel to split the text in cell A2 across rows wherever a comma occurs.

Since we didn’t specify a delimiter to use for the columns, Excel only splits the text vertically down the rows instead of horizontally across columns.

Note that you could also specify a different delimiter to use besides a comma if the text values in your cell are separated by a different delimiter.

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 Date into Day, Month and Year
Excel: How to Split String Based on Multiple Delimiters
Excel: How to Split Word into Individual Letters

Featured Posts

Leave a Reply

Your email address will not be published. Required fields are marked *