Wrap cell values in single quote so that regexprep works

My data has strings and digits. It looks something like:

C =

     {'N',[0],'Y',[75];

     'Y', '75', '0','N'}

When I run

C = regexprep(C,'N','99');

I get 'Error using regexprep: All cells must be strings.'

So, I thought I should wrap everything that isn't a string in single quotes.

I tried:

    for i = 1:length(C); 

        if ~isstr(C{i});
        C{i}= sprintf('%d', C{[i]});
    end

But it doesnt work. When i change {1} to {1,3} everything that wasn't a string in column 3 becomes a string, but this is inefficient because my data has >600 columns.

What can I do?

Thank you so much for your time and help!

Answer 1

[Sean de Wolski]

How about:

C = cellfun(@(x)num2str(x),C,'uni',false)

[Matt Fig]

Or:

@num2str

[Milou]

Thank you!

Answer 2

[Azzi Abdelmalek]

B= cellfun(@(x) regexprep(char(x),'N','99'),C,'un',0)

[Milou]

Thanks! This works as well, although it truncates the data.