Rob

When replacing with: hold the ALT key and type 0010 on the NumPad(gray keys on
the right).

You won't see anything typed in the box, but it is there.

Gord Dibben Excel MVP


On Mon, 3 Jan 2005 11:27:02 -0800, Rob wrote:

I have this same questions and This answer did not not work for me. It is
inserting"<alt0010". Not a hard return. Please help

"jo" wrote:

excel 2003
how to find text or symbol in each cell and replace with hard carriage return