Finding and Replacing Line Breaks?

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Ste_Moore01


Not sure about "Line Breaks", but if it is Page Breaks you want to replace...

This will reset all page breaks:

Sub ResetPageBreaks()
ActiveSheet.Cells.PageBreak = xlPageBreakNone
End Sub

John
 
Upvote 0
No I meant line breaks as in you press Alt+Enter when typing in a cell and it goes onto the next line.

I've manually changed them now, but I'm still curios as to whether this is possible or not.
 
Upvote 0
This worked for me on a single sheet.

Sub ReMoveLineBreaks()
Cells.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
End Sub
 
Upvote 0

Forum statistics

Threads
1,214,753
Messages
6,121,318
Members
449,026
Latest member
Nireeksha Shetty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top