It allows you to separate text into columns based on delimiters, such as commas or spaces, or by using fixed widths. ... 5 Ways to Instantly Split Cells into Columns & Rows in Excel.