How to split worksheet cells in Excel 2013 / 2016 / 2019?


Last update: September 2019

Here’s a question that we have received from a reader who wanted to divide a column vertically:

I am working on a statistical report in Microsoft Excel, using version 365. I just imported a comma separated value file  into the A column and  now need to split a column cell vertically into two “halfs”. Any simple way to get that accomplished? If it helps i am using Windows 10.

Thanks for the good question. For these scenarios i typically use the Text to Column feature, which serves my purpose pretty well. See below the full details.

Vertically split cells in Excel

Here’s how to vertically split cells in Excel (we have also a post covering dividing text into columns on Excel 2016 and 2019):

  • Open Excel and navigate to your worksheet
  • Highlight the cell(s) that you would like to split in halfs.
  • Now under Data tab, click on Text to Columns, that opens a dialog box.
  • In the dialog box, choose the best option to split your text. You have two options
  • Delimited – Splits text with a specified delimiter like comma, space, tab etc.
  • Fixed Width – Splits cells with a fixed value that is set.
  • If you select Delimited, you need to specify the delimiter in the next page. With the latter, you can drag the pointer to a particular width under Data Preview and click on Next.


Once you are done, click on OK and now you get the cells split as you specified.



More tips:

  • You can specify the type/format of the new column under Column data format.
  • Also, you can modify the destination of new column(which is the next cell by default) under Destination.

Horizontal split cells in Excel

Unlike when working with tables in Microsoft Word, PowerPoint and Outlook; there is no straightforward Split command for achieving horizontal splits in Excel cells. Readers having use cases about horizontal splitting could use specific formulas to divide their table data across two or more table cells in their worksheet.

 

Leave a Comment: