writing 1*5 char in one cell in excel
6 views (last 30 days)
Show older comments
alex
on 18 Nov 2011
Commented: Itamar Calderón Osuna
on 24 Mar 2019
i have a problem- i have parameter in matlab called patients = 82x5 type char when each row is like 234t1(has both numbers and a letter)
i want to import it to excel so that each patient name will be in one cell and not 5..( a1 = 234t1, a2 = 234t2,...)
how can i do that?
0 Comments
Accepted Answer
Fangjun Jiang
on 19 Nov 2011
xlswrite('test.xls',cellstr(patients))
2 Comments
Itamar Calderón Osuna
on 24 Mar 2019
Great help! Thank you!
I was sending a date to Excel and, instead of writing the full date in a single Excel cell, it wrote each character in a separate cell. After using cellstr() the problem was solved!
More Answers (1)
John
on 19 Nov 2011
Perhaps the following would work:
xlswrite('test.xls', cellstr(x))
Where "x" is a character array
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!