Does any one out there know how to remove a lot of hard returns from multiple
cells

Usually EditReplace works on the selection if the hard return is generate by
Alt + Enter in a cell.

What: CTRL + j

With: nothing

Replace all.

If generated by CHAR(10) in a formula, copypaste specialvalues first.


Gord Dibben MS Excel MVP

On Mon, 18 Jun 2007 17:31:01 -0700, ttribble
wrote:

Does any one out there know how to remove a lot of hard returns from multiple
cells

Does any one out there know how to remove a lot of
hard returns from multiple cells

You could run a macro similar to this (change the indicated range as
needed)....

Dim C As Range
For Each C In Range("b1:f3")
C.Value = Replace(C.Value, vbLf, " ")
Next

and then save the worksheet afterwards. The above macro removes each Line
Feed (what you are calling a "hard return") and replaces them with a single
blank space.

Rick

Or replace it with a space character?

(just in case <vbg)

Gord Dibben wrote:

Usually EditReplace works on the selection if the hard return is generate by
Alt + Enter in a cell.

What: CTRL + j

With: nothing

Replace all.

If generated by CHAR(10) in a formula, copypaste specialvalues first.

Gord Dibben MS Excel MVP

On Mon, 18 Jun 2007 17:31:01 -0700, ttribble
wrote:

Does any one out there know how to remove a lot of hard returns from multiple
cells

--

Dave Peterson

I just never remember to add that piece of info<g

Thanks, Gord

On Mon, 18 Jun 2007 19:57:14 -0500, Dave Peterson
wrote:

Or replace it with a space character?

(just in case <vbg)

Gord Dibben wrote:

Usually EditReplace works on the selection if the hard return is generate by
Alt + Enter in a cell.

What: CTRL + j

With: nothing

Replace all.

If generated by CHAR(10) in a formula, copypaste specialvalues first.

Gord Dibben MS Excel MVP

On Mon, 18 Jun 2007 17:31:01 -0700, ttribble
wrote:

Does any one out there know how to remove a lot of hard returns from multiple
cells