Split Text String by Line Break in Excel Office 365!!
Tags: excelpreface, splittextstringbylin, excelbasics, exceltutorials
Published: 2021-01-18 04:01:27

---
title: Split Text String by Line Break in Excel Office 365!!
published: true
date: 2021-01-11 04:41:06 UTC
tags: ExcelPreface,Splittextstringbylin,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/split-text-string-by-line-break-in-excel-office-365/
---

Do you want to break text string by line break? Just follow the instructions given in this article, and you will get the result as you wish. Here we come up with the simple and quick steps to **Split text string by line break** in Excel Office 365. We will achieve this by using the [FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/) and [CHAR function](https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/). Let’s jump into this article.
## Split Text String by Line Break:

To do this, we need to use a combination of the **[LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)**, **[RIGHT](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)**, **[CHAR](https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/)**, **[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)**, and [**FIND**](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)functions.

- **Left Function**  **–** It extracts the first character (starting from the left side) or characters from the given string based on the number you specified.
- **Right Function**  **–** It is used to extract the texts with the given number of characters from the right side.
- **Char Function**  **–** This is used to get a character by a specified number. It converts the given number into a character.
- **Len Function**  **–** It returns the length of a given text string as the number of characters.
- **Find Function**  **–** This function will find out the location of the text and returns the position as a number.

### Example 1:

- Refer to the below formula that will find the position of the line break character in cell B1 and extract all the characters to the **left** of the line break character.

**=[LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(B1,[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)([CHAR](https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/)(10),B1,1)-1)**

- In the below screenshot, you will see the **student’s name** and **marks** in **column**  **B**.
- Apply the above-given formula in **Cell C1** to get the output.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_0HvLRgylRa.png)<figcaption id="caption-attachment-20781">Enter the formula</figcaption>

- You will see the result as shown in the below image.

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

### Example 2:

- Refer to the below formula that will find the position of the line break character in cell B1 and extract all the characters to the **right** of the line break character.

**=[RIGHT](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)(B1, [LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(B1)-[FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)([CHAR](https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/)(10),B1))**

- In the below screenshot, you will see the **fruit’s name** and **rate** in **column**  **B**.
- Apply the above-given formula in **Cell C1** to get the output.

![Enter formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_aslWFw44Cg.png)<figcaption id="caption-attachment-20783">Enter formula</figcaption>

- You will see the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_07FudtaaoU.png)<figcaption id="caption-attachment-20784">Result</figcaption>

## Closure:

In the above article, we have provided the simple and quick steps to **Split text string by line break** in Excel Office 365. Drop your **feedback/suggestions** in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!