How to split cells in Excel

How to split cells in excel

Excel is great for data management, but sometimes files don’t import correctly. You can end up with a ton of information in one cell when you wanted it nicely separated. This is where splitting cells comes in. The process is similar to that of merging cells, but with a few key changes.

If you’re finding yourself with formatting issues, here are the steps that should help you to fix your data.

How to split cells in Excel:

1. Most of the time, you’ll find that the information you need to divide is separated by commas or semicolons. This will mean that you won’t need any advanced features and that you can get started by selecting your cell.

How to split cells in excel

2. Once you select your cell, head to the Data tab in the menu. In the Data tab, select the Text to Columns option. It’s next to the Flash Fill and Sort and Filter options.

How to split cells in Excel

3. Now you should see a wizard pop up to help you through the rest of the process. Step one displays an important distinction: Delimited and Fixed Width data. These are the two ways that your data can be separated inside the cell. Delimited means that your information already has commas or semicolons while Fixed Width data is divided by a consistent number of spaces. Since we have commas in our example, we’ll use Delimited.

split cells 3

4. Since we’ve indicated that we have delimited data, we’ll head to step two in the wizard. Here, we indicate how our data is divided up. Data can also be divided by Tabs, Semicolons, Spaces, and a few other characters. As you select your divider you’ll see the preview text box change to reflect your choice.

split cells 4

5. Excel does most of the work in the splitting process, but step three helps you double-check your formatting. You can indicate that your information is General, a Date, or Text, but for now, we’ll stick with General. You can also change the destination of your split in case you need the information in a specific part of your spreadsheet.

split cells 5

6. Click Finish, your data should now look like the picture below!

split cells 6

How can I learn more?

So there you have it: How to split cells in Excel. It really is that simple. However, not everything in Excel is quite so easy. If you want to learn more, the Ultimate Excel Bootcamp Bundle is an ideal guide. The learning kit packs nearly $1,400 worth of content into one package. Even better, you can save over $1,300 and get started for just $49.

The four courses in the bundle are:

If you’re ready to get started you can check out the details via the widget below.


$49
.00
The Ultimate Excel Bootcamp Bundle: Lifetime Access


Save

$1331
.00


Buy it Now


The Ultimate Excel Bootcamp Bundle: Lifetime Access

Buy it Now



Save

$1331
.00




$49
.00

Powered by WPeMatico

By | 2020-03-13T16:04:32+00:00 March 13th, 2020|Android Related, Deals|Comments Off on How to split cells in Excel

About the Author:

Vancouver, Canada