Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Data in Excel (not sure)

    I'm exporting data from our company's customer management database in to Excel. I'm running XP - Excel 2002. The export options are Lotus 1-2-3 and then it saves as works 1-2-3. After the information exports, there is a black bar at the end of each entry. It is not only visible, it prints. I've determined that it is a 'return'. Does anyone know how to remove it? I can't use find and replace and manual removal is taking hours. Please help if you can!

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Importing Data in Excel (not sure)

    Could you attach a small sample file? We need only a few lines/rows, and you should remove or replace sensitive information. You can zip the file to reduce the size of the attachment.

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Data in Excel (not sure)

    <P ID="nt"><font size=-1>(No Text)</font>

  4. #4
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing Data in Excel (not sure)

    HANS I LOVE YOU!!!!

    Thank you Sooooo much! <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Importing Data in Excel (not sure)

    The following macro will remove the ASCII 0 characters at the end of cells:

    Sub Remove0()
    Dim oCell As Range
    For Each oCell In ActiveSheet.UsedRange.Cells
    If Right(oCell, 1) = Chr(0) Then
    oCell = Left(oCell, Len(oCell) - 1)
    End If
    Next oCell
    End Sub

    You can copy this macro into a module in the workbook itself, or if you want to run it in several workbooks, copy it into a module in your Personal.xls. See Legare Coleman's <!post=Personal.xls Tutorial (All),118382>Personal.xls Tutorial (All)<!/post> if you need information about Personal.xls.

Posting Permissions

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