[Garf13LD]

My home pc is using china chinese as system locale.
I need to find and replace char(160) in excel.
It gives me ? and wipe everything clean in my sheet.
Any solution?
btw using win7 with office 2010

[Keebellah]

I think you've checked it too but extended ASCII is a problem:

http://www.globaliconnect.com/excel/...=78&Itemid=474

http://www.globaliconnect.com/excel/...=78&Itemid=474

I'll see if I can find something for you, but this is the first quick search.

You might just have to select the character, copy and then run a replace with?

[Garf13LD]

I got the temp solution to freeze the code.
if chr(160)="?" then
"do nothing"
else
.Replace What:=Chr(160), Replacement:="", LookAt:=xlPart
end if

[Keebellah]

I don't think a sample will work here but I could try, we have a 'Chinese' environment at work.

[Keebellah]

I don't think you have to eplicitly select Chr(160) but putthat character in a one lenght string

replace(yourstring,mid(yourstring,x,1),"") where x is the position of that particular character.

Is this an idea?

[Garf13LD]

the system detect it as 32, so I guess I can do a trim as the original data is from website.
Or I don't try to bring my work home. lol

[Keebellah]

I think the last option is good. I generally do go on at home