CODEWITHSUNDEEP
excelencoding
Vishal Sharma
Vishal Sharma

Reputation: 172

Excel : All other language symbols are getting converted to?

I'm dealing with 2 kinds of problems in excel: 1st - I need to copy some filenames but those with other language text get converted to ??? 

Example: file name ="foosｄアプ bar" will look like "foos??? bar in excel"

2nd - Also, symbols like bullet point in format • (utf-8) needs to be converted to their equivalent in excel.

Example : Text in excel = "• Be polite" needs to be converted to "• Be polite"

How do I solve this (Treat me as a beginner)

Upvotes: 0

Views: 128

Answers (1)

Abhimanyu Singh
Abhimanyu Singh

Reputation: 399

For the 1st one, you can use pasting the filenames as unicode text and for the second follow a trick to open the csv as a notepad and then save it as utf-8 csv.

Upvotes: 1

Related Questions