Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AscII Characters (97)

    I have a .csv format file, which I am exporting from Access 97. Two of the fields are memo fields in Access and transfer with AScII characters (little square) for returns. How do I get rid of them prior to sending the file? Many thanks.

    Blitz

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: AscII Characters (97)

    Hi Blitz,

    Before getting rid of them, you might try formatting the cells these fields go into as wrapped text. This may restore the original memo field formatting in your workbook.

    Alternatively, if you need to get rid of them, then open the workbook and try doing a Search/Replace, typing Alt-010 into the 'Find what' box and nothing in the 'Replace with' box.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AscII Characters (97)

    Hi thanks for the response - the transfer already seems to generate wrapped text. I have tried doing Alt 010 and Alt-010, with both the Alt key held down and released. It just seems to put a numeric value of "10" in, and nothing happens. I'm sure this is me making an ID 1 0T error (!) - what am I doing wrong?? Thanks Blitz

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AscII Characters (97)

    You hold down the alt key and type 010 on your numeric keypad. Then release the alt key. You'll see nothing in the find box, but don't worry, it will work.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: AscII Characters (97)

    Pressing Alt+0010 will do the trick for the Line Feed character, but I don't know how to do it for Carriage Return; Alt+0013 doesn't work. Try this instead:

    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type ActiveSheet.UsedRange.Replace vbCrLf, " " then press Enter.
    - Switch back to Excel

    If you need to replace only carriage returns or line feeds, you can use vbCr or vbLf instead of vbCrLf. And if you need to do this often, you can store the above instruction in a macro in a general module.

    Sub Returns2Spaces()
    ActiveSheet.UsedRange.Replace vbCrLf, " "
    End Sub

  6. #6
    Lounger
    Join Date
    Nov 2003
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AscII Characters (97)

    Thanks folks! I'll try this lot out.

    Regards. Blitz

Posting Permissions

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