Home |
Search |
Today's Posts |
#1
|
|||
|
|||
edit out ascii char 09
Hi.
I have a sheet created in SAS that has ascii char 09 which displays on the screen as a small square box (but prints OK), If I use the clear function, it removes the character all together leaving no space between the words. I can do a replace, but since this is a large sheet, and the cells have anywhere from zero to five char 9's, I have not been able to figure out a way of fixing this. Any suggestions |
#2
|
|||
|
|||
You could use a helper cell with a formula:
=substitute(a1,char(9)," ") Then copy|paste special|values and toss the bad column. Or maybe you could run a little macro... If you want to replace these characters with something else (space or nothing???), you could use a macro to do the edit|replace's: Option Explicit Sub cleanEmUp() Dim myBadChars As Variant Dim iCtr As Long myBadChars = Array(Chr(9)) For iCtr = LBound(myBadChars) To UBound(myBadChars) ActiveSheet.Cells.Replace What:=myBadChars(iCtr), Replacement:=" ", _ LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False Next iCtr End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm rugbyba wrote: Hi. I have a sheet created in SAS that has ascii char 09 which displays on the screen as a small square box (but prints OK), If I use the clear function, it removes the character all together leaving no space between the words. I can do a replace, but since this is a large sheet, and the cells have anywhere from zero to five char 9's, I have not been able to figure out a way of fixing this. Any suggestions -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using F2 to edit a cell | Excel Discussion (Misc queries) | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
edit Excel spread sheet | New Users to Excel | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
How to switch to edit the cell | Excel Discussion (Misc queries) |