Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Unanswered:

    Need to eliminate CRLF (soft return) within a single cell in all rows.
    User entered Address 1 and Address 2 data in Address 1 cell.
    Sheet has over 800 lines, so manually repairing is right out!
    Anyone have a VB sample subroutine?

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    String Replace will search for the string and replace all. You do not need to test for the existance of the find value. If the find value is not in the string it does not fail.

    strTxt = Replace(strTxt, Chr(10), " ")
    strTxt = Replace(strTxt, Chr(13), " ")
    ~

    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •