Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel CSV-UNICODE

Status
Not open for further replies.

italo2008

Technical User
Feb 13, 2010
1
IT
Hi (and sorry for my English...)

I need to modify in Excel a CSV file imported from another application. The file contain UNICODE fonts (it contains cyrillic fonts). I'm able to open and read the file correctly (in attachment you can find an example), but I can't modify it, because an Excel alert window tells me that CSV format contains elements wich aren't recognized by UNICODE... I need to modify some words in the CSV file and save it in CSV again using Excel (because the next step will be modifying it with a VBA script...) how can I do it?


thanks
 



Hi,

Do not try to OPEN the file.

Rather, IMPORT into a new workbook, using File > Import External Data > IMPORT. Use the DELIMITED option and select COMMA as the delimiter.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top