Getting rid of Alt + Enter

[Joe]

I inherited a workbook and the person used Alt Enter a
lot. I want to get rid of it. Is there a way to do
find/replace on the special character that causes the line
to wrap? I tried reformatting and I got the info on one
line but an additional character was added (looks like a
small rectangle).

 

[Jason Morin]

I would try Ctrl+A, then Ctrl+H, and while holding the ALT
key down, type 0012 with your numeric keypad inside
the "Find What" box. Then press Replace All.

HTH
Jason
Atlanta, GA

 

[Jim Rech]

You could run a simple VB routine like this:

Sub a()
Cells.Replace Chr(10), " "
Cells.WrapText = False
End Sub

If you want to operate only on the selected range, replace the Cells with
Selection.

 

[Dave Peterson]

I think Jason meant 0010.

And it may look like nothing happened in that dialog, but try it out.