Excel Formulas to Extract Multiple Lines From a Cell ~ Easy Tricks!!
Tags: excel, excelformula, excelformulas
Published: 2021-06-18 10:42:27

---
title: Excel Formulas to Extract Multiple Lines From a Cell ~ Easy Tricks!!
published: true
date: 2021-06-08 09:36:23 UTC
tags: Excel,ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-multiple-lines-from-a-cell-easy-tricks/
---

If you have a list of text strings that are separated by line breaks. Now, you want to extract these lines of text into multiple cells. How could you solve it with a formula in Excel? Here, we are going to see the simple formulas to **extract multiple lines from a cell in Excel**. Let’s get them below!! 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)

[![Extract multiple lines from a cell](https://geekexcel.com/wp-content/uploads/2021/06/Extract-multiple-lines-from-a-cell.png)](https://geekexcel.com/excel-formulas-to-extract-multiple-lines-from-a-cell-easy-tricks/extract-multiple-lines-from-a-cell/#main)<figcaption id="caption-attachment-46219">Extract multiple lines from a cell</figcaption>

## Generic Formula:

- If you want to extract the multiple lines from a cell in Excel, you can use the below formula.

**=[TRIM](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/)([MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)([SUBSTITUTE](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/)(A1,delim,[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(” “,LEN(A1))), (N-1)\*[LEN](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)(A1)+1, LEN(A1)))**

## Syntax Explanations:

- **TRIM** – It helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the [**TRIM function**](https://geekexcel.com/use-trim-function-in-microsoft-excel-2013-simple-methods/).
- **REPT** – In Excel, the **[REPT function](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)** is used to repeat characters a given number of times.
- **MID** – This function helps to extract the number (starting from the left side) or characters from the given string. Read more on the [**MID function**](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/).
- **FIND** – The Excel, **[FIND function](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)** is used to find out the one text string inside the other.
- **LEN**  – In Excel, the **[LEN function](https://geekexcel.com/how-to-use-len-function-in-microsoft-excel-365/)** is used to find the length of the text string.
- **SUBSTITUTE**  – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the [**SUBSTITUTE function**](https://geekexcel.com/how-to-use-substitute-function-in-microsoft-excel-2013/).
- **A1** – It represents the input value.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Plus operator (+)** – This symbol is used to add the values.

## Practical Example:

Refer to the below example.

- Here, we will enter the input text strings in **Column B**.
- Now, we need to extract the multiple lines from a cell.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/06/Input-Ranges-17.png)<figcaption id="caption-attachment-46220">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-25.png)<figcaption id="caption-attachment-46222">Enter the formula</figcaption>

- Finally, press the ** ENTER**  key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result1-2.png)<figcaption id="caption-attachment-46221">Result</figcaption>

## Verdict:

So yeah guys this is how you can **extract the multiple lines from the cell in Excel**. I hope this is helpful to you. Feel free to ask back any **questions** and let us know how it goes.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Extract a Last Two Words From a Cell ~ Quickly!!](https://geekexcel.com/excel-formulas-to-extract-a-last-two-words-from-a-cell/)**
- **[How to Count missing values in a list in Excel Office 365?](https://geekexcel.com/how-to-count-missing-values-in-a-list-in-excel-office-365/)**
- **[Excel Formulas to Convert Text into Numbers ~ Quick Solution!!](https://geekexcel.com/excel-formulas-into-convert-text-to-numbers/)**
- **[Excel Formulas to Extract the Month Number from Name!!](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/)**