Searching for a nonprinting Ascii character in Excel.

Posted on 2011-04-25
Last Modified: 2012-05-11
I am exporting from SAS to excel. In SAS, I have formatted ascii characters 10 and 13 so that there is a carriage return and line feed after certain data, which is supposed to export to excel. In excel, the resulting export shows an unknown character (little square with a question mark). I need to eliminate these from the output. How do I search for an ascii code in excel and delete all occurrences
Question by:joelmcm
    LVL 50

    Accepted Solution

    The simplest way is to copy one of those squares then use Edit > Replace on your data, copy the square into the "Find what" box and leave "Replace with" box empty

    regards, barry
    LVL 46

    Assisted Solution

    If you export into a CSV file, then when you import you have option to specify the line delimiters.  Excel will automatically remove them.   If this is a regular thing, then you could also set up a macro to automate it.
    LVL 24

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now