Finding and Replacing Line Breaks?

[Ste_Moore01]

How do you find a replace a line break in Excel?

 

[Datsmart]

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

 

[Ste_Moore01]

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.

 

[Datsmart]

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

 

[Ste_Moore01]

Thanks very much Datsmart!