On Mar 21, 1:43*pm, Dave Peterson wrote:
Try recording a macro when:

You select the range
Edit|replace
Find what: * * ctrl-j
replace with: *(spacebar)(spacebar)

Replace all

ctrl-j is the same as alt-0010 or alt-enter or =char(10). *

It may not look like that inputbox on the replace dialog didn't change, but try
it anyway.

andreashermle wrote:

Dear Experts:

For selected cells in a column, I would like to replace any line
breaks (Alt + Enter) with two spaces using a macro solution. There are
cells that have multiple line breaks!

*By the way: can this be achieved using the bulit-in search and
replace functionality as well?

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

--

Dave Peterson

Hi Dave,

thank you very much for your swift response. Your solution is the
first one I am trying out.
Great help. It works as desired.

Thank you very much for your professional help. Regards, Andreas