Convert cell array with different data type to a matrix in MATLAB

I imported an excel sheet on matlab in which some columns are characterized by different data, such as numeric values ​​separated by a slash (e.g. 7/8) and normal numeric values . The "cell2mat" command transforms only columns containing the same type of data. What can I do for the remaining columns?

[Stephen23]

"What can I do for the remaining columns?"

Lots of things. But nowhere in your question do you explain what you expect the output to be like.

What do you want strings like '7/8' to be converted into?

[ALESSIA ANTONACI]

The cell array that I created is made up of 141 rows and 8 columns. Of these 8 columns, some contain the same type of data, i.e. only numbers. Other columns, on the other hand, consist of both simple numbers and numerical values such as 7/8, or 5/6 and also text abbreviations (therefore they are composed of different types of data). Since building vectors for every single column, for those that have the same data type I used the "cell2mat" command. My problem is that I can't create vectors just for those columns containing mixed data. I apologize for not explaining the problem first but it is my first approach to Matlab.

[ALESSIA ANTONACI]

Furthermore, the vectors I want to create must contain the same data as the cell array

Answer 1

[Divya Gaddipati]

A similar question has already been answered by the community which might be of relevance to you. Please refer to the following link:

https://www.mathworks.com/matlabcentral/answers/878-how-do-i-convert-strings-stored-in-a-cell-array-to-numbers?s_tid=answers_rc1-2_p2_MLT

Hope this helps!

[ALESSIA ANTONACI]

Thank you very much