how to remove new line character

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mariyana
    New Member
    • Mar 2007
    • 11

    how to remove new line character

    We display an expression in excel , in which there are also some small boxes being diaplayed in expression.

    somes boxes are getting removed when we give
    replace(string1 ,vbnewline,"")
    but some are not.

    Are there any other keywords like vbnewline which displays small boxes, which when given will remove the small boxes
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    try using vbCrLf

    vbCrLf-----CarriageReturn LineFeed

    Comment

    Working...