How to write2 strings in a cell in Excel ?

Question

andrea 2014-11-5

评论： andrea 2014-11-5

This are 2 cell-array:

a={'Hi';'Hi'}; b={'Fred';'Alex'};

I would like to combine each row and write it in a cell in Excel like this:

    Hi Fred    (Column A, Row 1)
    Hi Alex    (Column A, Row 2)

Actually I do:

xlswrite('name.xls', [a,b]);

but the result is this:

    Hi (Column A, Row 1) Fred (Column B, Row 1)
    Hi (Column A, Row 2) Alex (Column B, Row 2)

Thanks in advance for your help!

Image Analyst 2014-11-5

Answer 1

per isakson 2014-11-5

编辑：per isakson 2014-11-5

[a,b] &nbsp creates a &nbsp<2x2 cell>. That's why you get 2x2 "cells" in Excel. &nbsp Instead try

    cac = cellfun( @(s1,s2) sprintf('%s %s',s1,s2), a, b, 'uni', false );
    xlswrite('name.xls', cac );

andrea 2014-11-5

Thanks!