Handling Strange Text Codes

[Atroxell]

Hi,

I am attempting to go back over some old, old code I have but need to revive for a campaign restart.

I have run into a problem translating one of the characters in the new report I am trying to import and clean up for easier use in Excel. This character appears in Excel as a small box with a question mark in it, and in my text editor it appears as "FF". My research tells me that this is probably some Unicode character, but I can not figure out how to capture it in a Select statement and act upon it.

Can someone point me in a direction so that I can have Excel react to this cell content?

TIA!

Update: When I use VBA to assign the character to a variable, it comes back as a "Variant/String" type and its value is displayed as a small box. Hth!

 

[mikerickson]

if the Cell is A1, put =CODE(MID($A$1, COLUMNS($A:A), 1)) in a cell and drag right to see what's in that cell.

 

[Atroxell]

Thanks for the quick response! You are right on track. Your formula uncovered that it is ASCII code 12.

I rarely have to deal with anything other than simple ANSI codes, so I get a bit bound up by unexpected characters.

So now I have a Select Case statement that looks something like

                ' Find header notations and/or empty rows to delete.
                For y = 9 To listEnd
                        Select Case Range("A" & y).Value
                                        .
                                        .
                                        .
                                Case Is = Asc(12)
                                        .
                                        .
                                        .
                          End Select

But the code is not recognized. What would the be the best way to test for the value?

 

[Atroxell]

I got it!

Instead of Asc(12), I used Chr(12).

Ty for your help. I just needed a little push to get the ball rolling.

(And help comes to me from Davis. I can look out my office window on a clear day and see Davis from where I am!)

 

[mikerickson]

Lincoln ??? Is that up towards Yuba City?

 

[Atroxell]

That's the one! But I work in Sacramento...