How to Remove Line Breaks in Excel (takes less than 10 Seconds)

In this video, I will show you how to remove line breaks in Excel (using Find and Replace).

Line Break is what makes it possible to have a new line in the same cell in Excel. In some cases, you may want to remove these line breaks and get all the data in one line only.

For example, if you have names data with the first name is one line and the last name in one line, you may want to remove the line break and get it all together in one line.

In this video, I will show you how to use Find and Replace to find all the line breaks and replace these with a blank or a comma. The trick here to tell Find and Replace to find line breaks, which you can do by using the keyboard shortcut Control + J.

This video is a part of my 'Excel is two-minute' series, where I share simple and quick tips to help you speed up your work and be more efficient

⚙️ Gear I Recommend:

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

[VandermondBG]

I don't know that Ctrl + J insert Linebreak. The =TRIM(CLEAN(B2)) function works just great.
Thank you!

[UpExcel]

CTRL+J represents line break ....never knew that. Great stuff 👍👍😀

[sanjaygupta-qjym]

Its a amazing shortcut cntrl+j I never knew this shortcut

[adarshag]

Really this small small things realy useful, and everyone should know this kind of excel

[puneetvij]

Sumit Sir,
Just Wow! Please continue with this type of series. ; )

[devendrabain]

Really sir you have saved my lot of time. Without this trick this task is very laborious. 👍👍👍👍

[mosadiq]

Awesome work. Keep up the good work. !!!!

[wayneedmondson]

Hi Sumit.. thanks for sharing this tip which is super helpful when you want to modify the data directly. In certain circumstances, like some of the commenters below, I use SUBSTITUTE to do it with a formula. It is kind of strange that you can't FIND and REPLACE CHAR(10) in the dialog box which would be more obvious. But, CTRL+J gets it done, even if somewhat of an obscure way of referencing the line break character. I use this often when cleaning data from third party sources. Thanks for sharing your knowledge. Thumbs up!

[alokjena]

NIce its very good tips. We also use =SUBSTITUTE(A2, CHAR(10), ", ") for this.

[ahmadridwan]

i have multiple line break, and i want to make it a single line break for each line could you help me with this?

[gmail]

Please help. Once I add the comma and delimited, only the first comma remaining

[dempseyroll]

I know by using Alt+Enter we get a line Break, but can't we use Alt+ Enter in Ctrl+ H( find and replace

[saiyadali]

I have 10 line break within a single cell...4 are blanks line break. So I wan to remove only blank line breaks and want to keep rest of the line breaks..Please help me

[AarumugamRajendran]

Hello Sumit, Suppose if I enter a Month in a cell, the excel should generate list of days in that month automatically. Please do the video for this task .

[simple-security]

if this doesn't work with excel for m365 desktop check the sensitivity on your document. if it's set to a non-public sensitivity you may not be able to perform special edits like this on your document because you're opening it on your 'public' workspace. and unfortunately this trick doesn't work in m365 cloud.

[TrentGustus]

I get.. "cannot find data specified' I cannot split the cell text to columns because of the line breaks.. and I can't remove the line breaks.

[brentcosta]

I don't see anything when I enter "Ctrl + J"?

[vanijain]

hello can you explain it in a clear way.

[shyamadasgupta]

Not working. I keep getting error : "We couldn't find anything to replace. It's possible your sheet is protected". My sheet is NOT protected.

[Blog_of_Truth]

Didn't Work. says "Couldn't Find anything to replace"