VBA - removing line breaks

[Ananthak275]

I have some cells that have line breaks that values that are split by line breaks. I would like to remove the line breaks in the cell.

Is it possible to assign a range to this VBA script? eg A3:D4

Original Cell	Transformed Cell
Apple Orange Banana	Apple Orange Banana

 

[Ananthak275]

Sub RemoveLineBreaks()

Dim ws As Worksheet
Dim LastRow As Long
Set ws = Worksheets("TEst1") '<- change sheet name

LastRow = ws.Range("A:B").Find("*", , , , xlByRows, xlPrevious).Row <- looks at last row between column A & B
ws.Range("A2:B" & LastRow).SpecialCells(xlCellTypeConstants).Replace Chr(10), " " '<- If needed, insert split between quotes. I only needed a space. Change range as required

End Sub

 

[Micron]

You can use code but don't have to. Here's a few ways

How to Remove Line Breaks in Excel (3 Easy Ways) - Trump Excel

Learn how to quickly remove line breaks in Excel with a few simple techniques (using Find and Replace, a formula method, and VBA)

trumpexcel.com

 

[Peter_SSs]

@Ananthak275
When posting code, please use one of the relevant Code tag options, not the Quote tags. I have fixed it for you this time.