Thread
:
want Replace ALT+ENTER to SPACE
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Avadivelan TCS
external usenet poster
Posts: 19
want Replace ALT+ENTER to SPACE
Sub CleanCR()
Selection.Replace What:=Chr(10), _
Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
End Sub
"arno" wrote:
maybe you should post your makro.
arno
Reply With Quote
Avadivelan TCS
View Public Profile
Find all posts by Avadivelan TCS
want Replace ALT+ENTER to SPACE