excel - Debugging whitespace in VBA -

i have cell in table reads:

64123 there sort of white space after 3. thought blank space, in vba code, i've tried multiple ways of getting blank space out of string, neither application.trim nor replace work.

with cells(c.row, 16)   .numberformat = "general"   v = application.trim(.text)   v = replace(v, " ", "")   debug.print v   .clear   .numberformat = "general"   .value = application.trim(v) end 

there blank space @ end - can see when highlight cell in excel, , application.trim has worked me. else other blank space? if it's tab or carriage return, what's replace syntax those?

run , tell ascii values of string

sub tellmewhatcharvalues(h string) dim     = 1 len(h)         msgbox asc(mid(h, i, 1))     next end sub 

for 7th char

sub tellmewhatcharvalues(h string) dim     msgbox asc(mid(h, 7, 1)) end sub