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.
Here’s how to vertically split cells in Excel (we have also a post covering dividing text into columns on Excel 2016 and 2019):
Once you are done, click on OK and now you get the cells split as you specified.