concatenating characters in different column to a string
1 view (last 30 days)
Show older comments
I want to store 1x5 array of strings ['a' 'b' 'c' 'd' 'e'] as a single string of 1x1 :'abcde'. How can I do that? I want to do this because if I export ['a' 'b' 'c' 'd' 'e'] to excel file then they appear in seperate columns. But I want to write them all in same cell.
0 Comments
Accepted Answer
Walter Roberson
on 4 Jun 2012
['a' 'b' 'c' 'd' 'e'] is not a 1 x 5 array of strings: it is a single string of length 5, 'abcde', exactly as you want.
{'a' 'b' 'c' 'd' 'e'} on the other hand would be a 1 x 5 cell array of strings. You can convert this cell array to a single string by using cell2mat()
0 Comments
More Answers (1)
Image Analyst
on 4 Jun 2012
Try this:
% Create sample data.
charArray = ['a' 'b' 'c' 'd' 'e']
% Turn it into a cell array.
myCellArray = {charArray}
% Write to cell c3 of Excel.
sheetNumber = 1;
cellReference = 'C3';
xlswrite('test_sheet.xls', myCellArray, sheetNumber, cellReference);
0 Comments
See Also
Categories
Find more on Cell Arrays 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!