Getting rid of Alt + Enter

J

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).
 
J

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
 
J

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.
 
D

Dave Peterson

I think Jason meant 0010.

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