View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter atherton Peter atherton is offline
external usenet poster
 
Posts: 9
Default special character - line feed


-----Original Message-----
How can I find a line-feed (alt + Enter) in a text cell

in Excel and replace it with a space. When we save our
Excel data to .csv and upload, our application bombs with
this special character.
.

Chris

Something like this

Sub Macro1()
Dim x
Dim c As Variant
x = Chr(10)
For Each c In Selection
c.Replace What:=x, Replacement:=" ", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False
Next c
End Sub

Regards
Peter