Searching for a nonprinting Ascii character in Excel.

Posted on 2011-04-25
Medium Priority
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

barry houdini earned 1000 total points
ID: 35460388
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 47

Assisted Solution

David earned 1000 total points
ID: 35460416
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

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

850 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