You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.
If you want to know how to split cells in Excel, you’ve landed on the right page.
Excel is a program that offers a great deal of power to users – providing, of course, if you know how to get the best out of it. Knowing how to split a cell is one of the essential tasks, and there are a few methods available to users, which we will explore in greater detail here.
So, without any further ado, let’s go through how to split a cell horizontally in Excel.
Scenario at hand: For this article, we are going to split the first and last names into two different columns. We will be using two different methods to split one cell into two in Excel, and both of them are pretty simple.