• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Split Cells in Excel

March 22, 2021 by Andrew Childress
Split cells in Excel

Splitting cells helps you spread data across multiple columns. It’s easy in a spreadsheet. Let’s learn how to split cells in Microsoft Excel.

Splitting cells helps you spread data across multiple columns. It’s easy to do in a spreadsheet. Let’s learn how to split cells in Microsoft Excel.

How to Split Cells in Excel

Imagine that you have a list of data, containing first and last names. Currently, these are all contained within a single column.

But perhaps you want the first names in one column, and the last names in another. This is especially common if someone sends you a spreadsheet with data not formatted the way you’d prefer. But thanks to Excel, the fix is an easy one.

Breaking content from one cell into other cells is called splitting cells. You can do it in just a few clicks in Excel.

To get started, click and drag to select the range of cells that you want to split. In our example, that’s cells A1:A3.

Split names before Excel

Next, find the Data tab on Excel’s ribbon. Click on it to open it, then find the Text to Columns button just right of center. Click there.

Split cells Excel

You’ll see a window launch, called Convert Text to Columns Wizard – Step 1 of 3. In most cases, you’ll want to keep the Delimited option that is already selected. Excel will auto-detect how your data is formatted, and choose between Delimited or Fixed width.

Split Excel cells

Click Next. The second step asks you to set the delimiters your data contains. In other words, this is where you tell Excel how to split your data. In this case, click the Space checkbox. In the Preview box below, you’ll see a quick look at how your data will be split across cells.

Excel split cells

As you can see, it splits first names from last names. Click Next again, and then click Finish. As you can see, you now have two columns. Column A contains first names, while column B contains last names.

First and last name in columns

This is a quick and easy way to make your data easier to read, view, and sort in Excel.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:New line in ExcelNew Line in Excel
Next Post:Bullet Points in ExcelExcel bullet point 2022

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top