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

    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.

    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
    Aberdeen, Scotland
    Open the code window and put something like this in

    Sub Test()
    Selection.Replace Chr(10), ""
    End Sub

    Then Highlight your area and run the Macro

Posting Permissions

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