How to Split Cells in Excel Vertically: Text and Layout

How-to basics · Updated November 18, 2026

To split text in an Excel cell into side-by-side columns, select the cells, then choose Data > Text to Columns, pick Delimited or Fixed width, set the split points, and select Finish. Excel does not literally divide one worksheet cell into two independent cells; it places the resulting pieces in adjacent cells. If you only need a visible divider, use a border instead.

“Split vertically” can mean either separating a cell’s contents into columns or drawing a line down the middle of a cell. The steps below explain both, with Text to Columns as the usual way to turn one text value into multiple usable columns. Before you begin, check what is to the right of your source data: the split results may replace anything in those cells.

What You’ll Need

  • An Excel workbook and the cell or column containing the content you want to separate.
  • A clear split rule, such as a comma, space, tab, or known character position.
  • Enough empty columns to the right for the results, or a separate destination area.
  • A backup copy of the data if it is important or difficult to recreate.

Step-by-Step

  1. Decide whether you need separate data or only a line. If you need to sort, filter, calculate with, or edit each part independently, split the text into adjacent cells. If the cell should remain one value and you only want it to look divided, skip to the border method in the Tips section.
  2. Inspect a few source cells and identify the pattern. For example, a list of entries such as “Mira Chen” uses a space between first and last names, while “Chen, Mira” uses a comma. Check several rows: if some entries contain extra spaces, commas, or other variations, one delimiter may not split every row as intended.
  3. Make room for the output. If the source is in column A and you expect two pieces, make sure column B is empty too. Text to Columns can write results over existing cells without first asking you to preserve them. To keep the original values or avoid overwriting other data, copy the source column to an empty area or use a new worksheet first.
  4. Select the cells to split. Click a cell in the source column if you want to process that column’s contiguous data, or select the specific range you need. Include the header only if you want it processed as data; otherwise, select the rows beneath it. Avoid selecting entire unrelated columns, which can make it harder to review the preview and the result.
  5. Open the conversion tool. On Excel for Microsoft 365 on Windows, go to Data > Text to Columns. The Convert Text to Columns Wizard opens. Excel for Mac also provides Text to Columns on the Data tab, though ribbon layout and dialog appearance can differ slightly. If the command is not visible, widen the Excel window or look for it among the Data tab’s data tools.
  6. Choose Delimited or Fixed width. Pick Delimited when a character marks each boundary, such as a comma, tab, semicolon, or space. Pick Fixed width when each part starts at a consistent character position, regardless of which characters appear there. For example, a consistent code with its first four characters as a department identifier may suit Fixed width.
  7. Set the split rule and check the preview. With Delimited selected, choose the delimiter checkbox that matches your data. If the separator is a custom character, select Other and type it in the box. Use the preview to confirm that each piece lands in the intended column. If the preview breaks a name at every space, for instance, a multi-part name may create more columns than you want.
  8. Adjust text handling if needed. For Delimited data, the Treat consecutive delimiters as one option can prevent empty results when repeated separators should count as a single boundary. Use Text qualifier when fields are wrapped in quotation marks and contain delimiters that should stay inside a field. In the final wizard step, set a column’s data format to Text if values such as 0017 must keep their leading zeros.
  9. Choose where the pieces should go. In the final step, set Destination to the upper-left cell where the results should begin. For example, if the source is in A2 and you want to keep it unchanged, choose an empty area such as C2. Confirm that the destination has enough clear columns for every piece shown in the preview.
  10. Finish and verify the results. Select Finish, then inspect the first, middle, and last rows. Check that text is in the correct columns, leading zeros have been preserved where needed, and the original data remains available if you intended to retain it. If you used the source column as the destination, the original text may have been replaced by the first output piece.

Example: Suppose A2 contains East, 104, Open, and the same comma-separated pattern continues down column A. With the rows selected, choose Data > Text to Columns, choose Delimited, select Comma, and review the preview. Set the destination to B2 if column A should stay as the original. After Finish, the three pieces appear in B2, C2, and D2. If the spaces after commas are also included in the result, select the Space delimiter as well only if spaces are genuine boundaries in your data; otherwise, trim or clean up the result separately.

Optional formula method: For a repeatable split that updates when the source changes, use TEXTSPLIT in an empty cell. With the text to separate in A2 and a comma as the delimiter, enter =TEXTSPLIT(A2,",") in B2. In Microsoft 365 or Excel 2024, the result spills horizontally into neighboring cells. For the example East,104,Open, the cells return East, 104, and Open. Keep the spill area empty; existing content can cause a #SPILL! error. TEXTSPLIT is not available in every older Excel version, so use Text to Columns if Excel does not recognize it.

Common Mistakes

  • Expecting one cell to become two independently sized cells. Excel’s worksheet grid does not support dividing a single cell into smaller cells. Text to Columns puts the pieces into neighboring grid cells, which may affect the layout of the rest of the sheet.
  • Overwriting data to the right. If the selected source starts in A and the split creates three pieces, the output may occupy A through C. Move the destination first or make a copy before finishing.
  • Choosing the wrong delimiter. Selecting Space for a field that contains multi-word names can divide the name into several columns. Use the preview to catch this before committing.
  • Dropping leading zeros or changing dates. Excel may interpret values as numbers or dates. Set relevant output columns to Text in the wizard, or format them as Text before importing or entering data.
  • Including a header by accident. A header such as “Customer name” may be split just like the rows beneath it. Leave the header out of the selection or plan to restore it afterward.
  • Assuming a visual line changes the data structure. A border can make a cell look divided, but it remains one cell and cannot hold two separate values.

Tips

  • Use a copy when the original matters. Copy the source to a spare column or worksheet before splitting. That gives you a quick way to compare the output with the original or start over.
  • Prefer a specific delimiter to a broad one. A comma is usually safer than a space when commas consistently separate fields and spaces occur within names or descriptions. If separators vary, clean the data or test a small sample before processing the full range.
  • Choose Fixed width for consistent positions. In the wizard’s Fixed width view, add or move break lines in the preview to define where columns begin. This is useful for consistently formatted records, but it can split values incorrectly if character positions vary between rows.
  • Use a border for appearance only. Select the cell, then use Home > Borders to apply a suitable border. To create a line down the middle of a cell, use a diagonal border only if that appearance fits your design; Excel’s standard borders outline cell edges and do not create a true internal vertical divider. For a clean side-by-side layout, use two adjacent cells and format their borders.
  • Keep the source and results organized. Add clear headings above the new columns and check that the output range does not overlap a table, formulas, or merged cells. If the split is part of a recurring import, keep a short note of the delimiter and destination so you can repeat the same process reliably.

Troubleshooting

  • The split results are not in separate columns. Reopen Text to Columns and confirm that Delimited is selected and that the correct delimiter checkbox is on. Check the wizard preview before finishing. If the entire entry stays together, the chosen delimiter may not match the actual character; a regular space and a nonbreaking space, for example, are different characters.
  • Some rows split correctly but others do not. The source may use inconsistent separators or contain extra delimiters. Inspect the rows that failed and decide whether to standardize the source first, use a different delimiter, or process the irregular entries separately. Avoid applying a broad delimiter such as Space until you know how it affects multi-word values.
  • Existing values disappeared. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if you have not made other changes since the split. Then repeat the operation with a safe destination or restore the original from a copy. Undo may no longer be available after closing the workbook or performing later actions.
  • Numbers, dates, or IDs changed format. Undo if necessary, run the wizard again, and set the affected output column to Text in the final step. For IDs that already lost leading zeros, you may need to recover the original values from the source or a backup; changing the displayed number format cannot restore zeros that are no longer part of the stored value.
  • The formula returns #SPILL! or #NAME?. For #SPILL!, clear cells to the right of the formula where the split results need to appear, and check for merged cells in that area. For #NAME?, your Excel version may not support TEXTSPLIT; use Data > Text to Columns instead, or open the workbook in Microsoft 365 or Excel 2024.
  • You cannot see Text to Columns. Confirm that you are on the Data tab and that the Excel window is wide enough to display the ribbon commands. If you are using a different platform or a restricted workbook environment, use an available Excel desktop version or the formula method where supported.

Frequently Asked Questions

Can I split one Excel cell into two cells vertically?
Not as a change to the worksheet grid. Excel cells cannot be divided individually. You can split the cell’s contents into adjacent columns with Text to Columns or use two existing cells to create the layout you want.

Does Text to Columns split data down rows or across columns?
It separates each selected cell’s contents across columns. Each source row remains on its original row, with the parts placed in neighboring columns.

Can I split a cell without losing the original text?
Yes. Set the wizard’s Destination to an empty range, or copy the source to another column or worksheet before splitting. Make sure the destination has enough empty cells to hold all the results.

How do I split a cell at a particular character position?
Choose Fixed width in the Text to Columns Wizard and place the break line where the first piece should end. Check several rows in the preview to make sure the position is consistent across the selection.

Can I split a cell visually without changing its contents?
You can apply borders to create a visual separation, but the cell remains one cell. If the two sides need independent text, formulas, or formatting, use two adjacent cells instead.

Will Text to Columns update automatically when I edit the original?
No. Text to Columns performs a conversion; it does not maintain a live link to the source. A supported TEXTSPLIT formula can update when its source changes, provided the spill range stays clear.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.