Split text in excel using formula

    split a cell vertically in excel
    split a cell horizontally in excel
    divide a cell horizontally in excel
    can i split a cell vertically in excel
  • Split a cell vertically in excel

    • Split excel cell into two rows

  • Split excel cell into two rows
  • How to split a cell into two rows in excel 2016
  • Split excel cell into two columns
  • Excel split cell formula
  • Split cells in excel shortcut

    • Split excel cell into two columns...

    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:

    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

      • how do you split a cell vertically in excel
        can you split a cell horizontally in excel