How can I split up several data (string, number) in one cell from an excel file?
4 views (last 30 days)
Show older comments
Hello community,
I am new to matlab and I imported an excel file which includes data of string, number and dates (all data are in the same column) and I want to split it into 3 columns.
Information of the data:
example:
Person XYZ
12345678
01.01.1990
Person ABC
19876543
01.11.1995
and I want to "transpose" the data like that:
column 1 column 2 column 3
Person XY 12345678 01.01.1990
Person ABC 19876543 01.11.1995
I think its not that difficult to solve this problem, I already tried so solve it with a for loop and if statement but I have some problems to get the right syntax.
Thanks in advance!
stay safe!!! :-)
2 Comments
dpb
on 7 Apr 2021
And, in fact, given the mixed content in the file, you'll get a column of cellstr() when you read the Excel file automagically so really have almost nothing left to do! :)
Answers (0)
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!