macros

[radha]

i need to remove alt-enter character from a work book which contains 7 work sheets


thanks
radha

[p45cal]

For Each sht In ActiveWorkbook.Sheets
sht.Cells.Replace What:=Chr(10), Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Next sht