Importing / Xlsread: How to replace unknown character?

clearvars;
filename = 'ABB';
[ num,txt,raw ] = xlsread( char(filename) );

Problem with above: how do I replace an unknown character, i.e. a character that's not in the English language when importing from an Excel-file?

E.g. the Swedish letter ö? When I'm screening the document through Matlab I just see a question mark.

[Walter Roberson]

What is the file extension? Is it a .csv, or a .xls, or a .xlsx ?

[Hampus]

It is xls

Answer 1

[Santhana Raj]

Instead of using xlsread, use readtable.

one of its options is fileEncoding. I am sure it can read Swedish, but you can explore in that direction.

another suggestion is to replace '?' with space after reading the whole xls file.