Split Cell Contents by Space/Newline/Comma/Period in Excel 365
Tags: kutoolsexceltutorial, splitcellcontentsbys, kutools
Published: 2020-10-01 12:27:00

---
title: Split Cell Contents by Space/Newline/Comma/Period in Excel 365
published: true
date: 2020-10-01 12:18:42 UTC
tags: KutoolsExcelTutorial,SplitCellContentsbyS,Kutools
canonical_url: https://geekexcel.com/split-cell-contents-by-space-newline-comma-period-in-excel-365/
---

## Split Cell Contents by Space/Newline/Comma/Period in Excel:

In this article, we are going to explore how to **Split Cell Contents by Space/Newline/Comma/Period in Excel Office 365** using **Kutools** with examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Split Cell Contents into Multiple Columns or Rows by Space/Comma/Newline:

To split cell contents into multiple columns or rows by space or comma or newline, do as follows.

- In the following image, you can see the example of **cell values separated by a comma**. Let’s see how to split them in step-by-step instructions.
- You need to **select cell values** that you want to split into multiple columns or rows.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-1.png)<figcaption id="caption-attachment-14935">Example data</figcaption>

- Go to the **Kutools Tab, select** the **Merge & Split** option, and **choose**  **Split Cells** option from the drop-down list.

![Select the Split Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Split-Cells-option.png)<figcaption id="caption-attachment-14936">Select the Split Cells option</figcaption>

- It will open the **Split Cells dialog box**.
- If you want to **split the values into multiple columns** , then **choose** the **Split to Columns** option under the **Type** section.
- You can also **choose** the **Split**  **to Rows** option under the **Type** section, to split the values into multiple rows.
- Then, you need to **choose the separator** such as space, newline, semicolon to split the cells.
- You can also specify other delimiters as you wish using the **Other** text box.
- Hit the **OK** button.

![Split Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Split-Cells-dialog-box.png)<figcaption id="caption-attachment-14937">Split Cells dialog box</figcaption>

- Now, the **Split Cells dialog box** will pop out to tell you to **select a blank cell** to display the result.
- **Click** the **OK** button.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-a-cell.png)<figcaption id="caption-attachment-14938">Select a cell</figcaption>

- Now, the selected cells have been **split into multiple columns/rows** as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output.png)<figcaption id="caption-attachment-14940">Output</figcaption>

## Split Text and Numbers Mixed in One Cell/Column into Two Cells/Columns/Rows:

If you have text strings mixed with the text and numbers and you need to split them, do as below steps.

- Let’s consider an example data as shown in the below image where you can see the combination of text and numbers.
- You need to **select the text strings** that contain text and numbers.

![Sample text strings](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Sample-text-strings.png)<figcaption id="caption-attachment-14941">Sample text strings</figcaption>

- Go to the **Kutools Tab, select** the **Merge & Split** option, and **choose**  **Split Cells** option from the drop-down list.

![Select the Split Cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Split-Cells-option.png)<figcaption id="caption-attachment-14936">Select the Split Cells option</figcaption>

- It will open the **Split Cells dialog box**.
- If you want to **split the values into multiple columns** , then **choose** the **Split to Columns** option under the **Type** section.
- You can also **choose** the **Split**  **to Rows** option under the **Type** section, to split the values into multiple rows.
- In the **Split by** section, you need to **choose** the **Text and number** option.
- **Click** the **OK** button.

![Split Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-1.png)<figcaption id="caption-attachment-14942">Split Cells dialog box</figcaption>

- Then, the **Split Cells dialog box** will pop out to tell you to **select a blank cell** to display the result.

![select a blank cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-1.png)<figcaption id="caption-attachment-14945">select a blank cell</figcaption>

- Now, the text and numbers are split and displayed in different columns or rows as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-1.png)<figcaption id="caption-attachment-14947">Output</figcaption>

## Verdict:

In this article, you can clearly understand the steps to **Split Cell Contents by Space/Newline/Comma/Period in Excel Office 365** using **Kutools** with examples. Leave your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Compare Two Ranges of Cells If they are Equal or Different in Excel 365!](https://geekexcel.com/compare-two-ranges-of-cells-if-they-are-equal-or-different-in-excel-365/)
- [Lookup a Value and Return a Different Cell From the Table in Excel!!](https://geekexcel.com/how-to-lookup-a-value-and-return-a-different-cell-from-the-table-in-excel/)