Excel Formulas to Remove the Line Breaks Between Two Text Strings!!

Assume that you have a list of values, and you need to remove the line breaks between two text strings in Excel? Do you have any good ideas to deal with the task? Today I will introduce some methods to achieve it. Let’s get into this article!! 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 remove the line break between two text string, you can use the below formula.

Syntax Explanations:

SUBSTITUTE – This function can 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.

CHAR – In Excel, the CHAR function helps to get a character by a specified number.

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.

Practical Example:

Refer to the below example image.

Here we will enter the input text strings in Column B.

Now we are going to delete all the extra spaces from the starting and end of the text string.

Select any cell and type the above-given formula.

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

Closure:

Hope you like this article on how to remove the line breaks from the text string in Excel. Hope you like this article. If you have any questions , feel free to comment.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

Excel Formulas to Remove the Last Word ~ Easy Tutorial!!

Formulas for Counting Rows that Matches Two or More Criteria in Excel!!

Excel Formulas to Remove the First Character ~ A Complete Tutorial!!

Excel Formulas to Remove File Extension from Filename ~ Simple Tricks!!