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