Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following loop in a function to get rid of unprintable
chararcters (car ret, line feeds, etc) in a cell. It works fine most of the time, but something is getting by it. I keep running into a cell that has one char that always remain (I can see it is taking up a space, but I cannot identify it). Can I change this loop to leave only a-z A-Z 0-9? Or at the very least, leave only chracters I can see? Thnak you Function eliminate_unprintable_chars(chars) For i = 1 To Len(chars) If Mid(chars, i, 1) " " Then ...I have a good character here, now save it.... End If Next i End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can you make an Excel Worksheet unprintable | Excel Discussion (Misc queries) | |||
How can I delete unprintable characters using VBA in Excel? | Excel Programming |