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