Excel import single '

Hi! Im trying to load an excel sheet using function xlsread. Some of its cells look like this: ‘900/8

i.e. with one single ‘ in the beginning. Nothing is loaded from these cells. Id prefer to fix this in Matlab using some other loading command. If its not possible, can I save my excel file in a smart format enabling loading of these cells. If that’s also impossible, can I remove the single ‘ in some way in Excel?

Thanx for your help, Simon

Answer 1

[Oleg Komarov]

So if you have an excel that look like this:

'900/8 30 20
'600/7 10 30

[num,txt] = xlsread(...);

Look at txt, your data is imported as class char and is stored in a cell array of strings. You have to convert them back to numeric class with:

• textscan or
• str2num or
• str2double