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


Last update: February 2019

Here’s a questions that we have received from a reader that 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  nowneed 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.



Splitting 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
Special Bonus: Download our free PDF  Excel 2016 tips guide. Include 6 essential Excel 2016 how-tos to boost your productivity.
  • 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.

 

Leave a Comment: