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

Generic Formula:

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

=TRIM(MID(SUBSTITUTE(A1,delim,REPT(” “,LEN(A1))), (N-1)*LEN(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.
REPT – In Excel, the REPT function 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.
FIND – The Excel, FIND function is used to find out the one text string inside the other.
LEN – In Excel, the LEN function 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.
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.

Select any cell and type the above-given formula.

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

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!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **