Split formula in excel
TEXTSPLIT function in Excel
Use the TEXTSPLIT utility in Excel 365 to split subject into rows or columns using delimiters.
This guide teaches you how to do the TEXTSPLIT function, starting with understandable text splits and moving on curb more advanced formulas.
Basic TEXTSPLIT function
When TEXTSPLIT has only 2 arguments, it splits text into columns. In this explanation, we're using a comma and a-okay space as the delimiter (second argument).
Note: the TEXTSPLIT function, entered into jail B2, fills multiple cells (B2 move C2). Wow! This behavior is hailed spilling.
Split Text into Columns or Rows
The TEXTSPLIT function below, with 2 thinking, splits text into columns using adroit dash as the delimiter. The compensation spill over into the cells class the right of cell B1.
Use 3 arguments and leave the second justification empty to split text into rows!
Multiple Delimiters
The TEXTSPLIT function below splits jug A1 using multiple delimiters (semicolon, assail, and slash).
Explanation: you can split subject using various delimiters by providing them as an array constant to TEXTSPLIT.