Find and replace blank line break.

robertmonaco

New Member
Joined
Jun 16, 2015
Messages
4
Solid front and top glass heated

Sliding rear doors (600 model hinged)

Deck forced refrigeration


to:


Solid front and top glass heated
Sliding rear doors (600 model hinged)
Deck forced refrigeration


I am using Microsoft Office for Mac 2016.

I have tried a bunch of formulas to find CHAR(10)/CHAR(13). All I end up with is the three lines of text running into each other.

Any help would be appreciated.

Thanks.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Akuini

Well-known Member
Joined
Feb 1, 2016
Messages
2,936
Office Version
  1. 365
Platform
  1. Windows
Try this macro:
Code:
Sub abc()
    Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
End Sub
 

robertmonaco

New Member
Joined
Jun 16, 2015
Messages
4
Try this macro:
Code:
Sub abc()
    Selection.Replace What:=Chr(10) & Chr(10), Replacement:=Chr(10), LookAt:=xlPart
End Sub


Thanks for the suggestion...

I made a slight edit to the formula as it didn't work to begin with.

Chr(10) replaced with Chr(13).

Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,576
Members
414,079
Latest member
Frills

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
Top