Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    113

    Unanswered: how do i get rid of 2lines in each cell?

    hey guys. I recently did a data export from my access database. How do i get rid of 2 line returns in each cell so it's all on one line. It looks like there is a tab in a stream of text such as address. here are some examples;

    "350 S. Grand Ave.
    43rd Floor"


    "8301 Florence Ave.
    #318"


    how do i get those like this "350 S. Grand Ave. 43rd Floor"
    "8301 Florence Ave. #318".

    Theres about 700 and it's way too time consuming to go to each one and press back space. What is the most efficient way to hadle this?? Thanks guys

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Open the code window and put something like this in

    [code]
    Sub Test()
    Selection.Replace Chr(10), ""
    End Sub
    [\code]

    Then Highlight your area and run the Macro
    HTH
    Dave

Posting Permissions

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