How do I read out a specific string/value out of one excel cell
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Benedikt Friedl
am 5 Okt. 2021
Beantwortet: Geoff Hayes
am 5 Okt. 2021
Hi,
I want to lable my x-axis with a string from a excle cell. My problem is that in that specific cell are more then one strings. So e.g. in my cell 'A14' is "house, garden, dog", all seperated with a comma and I just want to have the string "garden" to lable my x-axis.
hope you can help me
0 Kommentare
Akzeptierte Antwort
Geoff Hayes
am 5 Okt. 2021
@Benedikt Friedl - take the cell data which is the comma-separated string and then use split to split the string at the commas:
myString = 'house,garden,dog';
splitStringArray = split(myString, ',');
xLabel = splitStringArray{2}
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!