ExcelBanter - Convert a column to unicode

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert a column to unicode (https://www.excelbanter.com/excel-discussion-misc-queries/65324-convert-column-unicode.html)

James Ma

Convert a column to unicode

We have some excel file which contain some non-unicode(ANSI) column(Chinese
chars,unreadable).
Is there any way that we can convert them to the unicode(readable) format?

Thanks in advanced.

Gary''s Student

Convert a column to unicode

1. select the column
2. pull-down:
Format Cells... Font and select Arial Unicode MS
--
Gary's Student

"James Ma" wrote:

We have some excel file which contain some non-unicode(ANSI) column(Chinese
chars,unreadable).
Is there any way that we can convert them to the unicode(readable) format?

Thanks in advanced.

James Ma

Convert a column to unicode

Hi,
I have tried this way,but it's not working.There are remain the same chars.

"Gary''s Student" wrote:

1. select the column
2. pull-down:
Format Cells... Font and select Arial Unicode MS
--
Gary's Student

"James Ma" wrote:

We have some excel file which contain some non-unicode(ANSI) column(Chinese
chars,unreadable).
Is there any way that we can convert them to the unicode(readable) format?

Thanks in advanced.

All times are GMT +1. The time now is 01:02 AM.