Trouble with Chinese Characters

[Nikhilgupta]

Hi,
I am using Oracle db as data source for my excel to fill.

There are some chinese characters in the database which are not getting displayed correctly in my excel's cell.
For e.g. 测试 is getting displayed as ??

Can someone please help in this.

Thanks in advance.

[bhatt_ji]

If you want to use excel formula then you can use "Clean" function.
=Clean(Value)

Hope it will help you.

Bhatt

[Nikhilgupta]

I don't want them to be cleared or removed instead I want them to display in the cell as it is.
Means, if the value in the database is 测试 then it should be displayed in the excel's cell as 测试 not ??. Hope it clears my question now.