Hello,

I have an sheet with 3 columns (ID, english text, chinese text).

In a loop i go through all the rows and try to get english and chinese text
values using Str() fuction.

It works good with english text but not with thechinese one (it looks like
"????").

Any ideas ?

Thanks.

try Cstr() rather than Str()


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Petr Pavelka" wrote in message
...
Hello,

I have an sheet with 3 columns (ID, english text, chinese text).

In a loop i go through all the rows and try to get english and chinese
text
values using Str() fuction.

It works good with english text but not with thechinese one (it looks like
"????").

Any ideas ?

Thanks.

Sorry, I am the beginner.

Shall I use something like:

CStr(Range("C3").Value)

This doesn't solve my problem. I need to get numeric (byte) representation
of the chinese string from cell 'C3'.

Thanks.

"Charles Williams" wrote in message
...
try Cstr() rather than Str()


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Petr Pavelka" wrote in message
...
Hello,

I have an sheet with 3 columns (ID, english text, chinese text).

In a loop i go through all the rows and try to get english and chinese
text
values using Str() fuction.

It works good with english text but not with thechinese one (it looks
like
"????").

Any ideas ?

Thanks.

Not sure what you are looking for: If what you want is the unicode numbers
corresponding to the unicode string then assign it to a byte array.

Dim arrBytes() As Byte

arrBytes=range("C3").value

This will give you two array elements for each character. the two array
elements contain the two Unicode bytes.


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Petr Pavelka" wrote in message
...
Sorry, I am the beginner.

Shall I use something like:

CStr(Range("C3").Value)

This doesn't solve my problem. I need to get numeric (byte) representation
of the chinese string from cell 'C3'.

Thanks.

"Charles Williams" wrote in message
...
try Cstr() rather than Str()


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Petr Pavelka" wrote in message
...
Hello,

I have an sheet with 3 columns (ID, english text, chinese text).

In a loop i go through all the rows and try to get english and chinese
text
values using Str() fuction.

It works good with english text but not with thechinese one (it looks
like
"????").

Any ideas ?

Thanks.