ExcelBanter - excel 2007 csv gibberish

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - excel 2007 csv gibberish (https://www.excelbanter.com/new-users-excel/264363-excel-2007-csv-gibberish.html)

excel 2007 csv gibberish

I'm using Office 2007 English. When I open a previously saved csv file that
was saved containing Hebrew text, it opens as gibberish. When I open saved
Excel file that is Hebrew it opens correctly. Why would cause this to happen
suddenly?

excel 2007 csv gibberish

How are you saving the CSV file? Did it work in Excel 2003?

While saving as CSV pick 'Unicode Text (.txt)" option and see whether it
solves the problem.

Normally text files (CSV) contain English characters only (ASCII chars upto
127). Hebrew Characters are beyond 127... so you need to save in Unicode.

"Fran" wrote:

I'm using Office 2007 English. When I open a previously saved csv file that
was saved containing Hebrew text, it opens as gibberish. When I open saved
Excel file that is Hebrew it opens correctly. Why would cause this to happen
suddenly?

.