LinkBack URL
About LinkBacks
Hello Everyone,
After importing text files into excel I noticed that there are some ASCII Character codes found in some cells. How can I remove these non-printable characters.
Regards,
Vikas
Hello Everyone,
After importing text files into excel I noticed that there are some ASCII Character codes found in some cells. How can I remove these non-printable characters.
Regards,
Vikas
Not sure if this will work for them all, but try TRIM in a helper column...
=TRIM(cell-ref)
You may also need to ID the ascii code and use SUBSTITUTE()
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Clean() function removes all non printable characters from text
http://www.techonthenet.com/excel/formulas/clean.php
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Except for the char 160 nbsp character.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
duh, thank humding, I meant clean, not trim, it was late, thats my excuse lol
Maybe this will help
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks