Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

Importing UTF-8 Encoded CSV Files. Problem

Hi

I am importing UTF-8 encoded CVS files into Excel. Excel shows odd
characters in cell A1 as it interprets the UTF file signature as real data.

The bottom line is that Excel does not recognise a UTF-8 file when it sees
one.

Is there a way to get Excel to ignore the UTF encoding signature and show
only the data in the first cell?

Thanks
Rob.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel docs opening encoded	jackievar	Excel Discussion (Misc queries)	3	November 10th 07 08:40 PM
importing csv files	joelb	Excel Discussion (Misc queries)	2	June 7th 06 04:53 PM
How to open a UTF-8 encoded CSV file in Excel	Elayaraja	Excel Discussion (Misc queries)	3	April 18th 06 11:26 AM
Importing files	stina	Excel Discussion (Misc queries)	3	March 29th 06 11:14 AM
importing csv files, problem with date formats	jiwolf	Excel Worksheet Functions	5	March 7th 06 12:48 AM

All times are GMT +1. The time now is 09:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us