Mixed data types cell to string

Using xlsread I read the a spreadsheet

[ndata, text, alldata] =  xlsread(filename);

One cloumn of alldata is a mixed data types as shown below (strings and integers). As I wish to use it for further analysis, is it possible to convert all this cell to be strings?

Thanks.

Cell output:

      'NoGroup'
      'NoGroup'
      'NoGroup'
      [1]
      [1]
      [1]
      [2]
      [2]
      [2]
      [2]
      [2]
      [2]
      'Group3'
      'Group3'
      'Group3'

Answer 1

[Jan]

C = {'NoGroup', 1; 2; 'Group3'};
for iC = 1:numel(C)
  if ~ischar(C{iC});
    C{iC} = num2str(C{iC});
  end
end

There are alternatives like cellfun('isclass', C, 'char') or sprintf('%g', C[iC}).

[Daniel Kin]

Thanks