Concatenate strings and numbers

117 views (last 30 days)
Robert Demyanovich
Robert Demyanovich on 9 Mar 2022
Edited: DGM on 9 Mar 2022
I'm using the following code to try and create a "Range" for importing an excel spreadsheet into MATLAB. Instead of getting a single string, I am getting a 1x2 string for CoeffsRange. MaxRows is the number of rows in the Excel spreadsheet that contain data. Here's the code
String1=num2str(MaxRows)
CoeffsRange = ["H2:K" String1]

Accepted Answer

DGM
DGM on 9 Mar 2022
Edited: DGM on 9 Mar 2022
Strings and chars are different. Take care in how you combine them.
MaxRows = 10;
String1 = num2str(MaxRows) % a char vector
String1 = '10'
CoeffsRange = ["H2:K" String1] % [string char] -> string array
CoeffsRange = 1×2 string array
"H2:K" "10"
CoeffsRange = ['H2:K' String1] % [char char] -> char vector
CoeffsRange = 'H2:K10'
CoeffsRange = "H2:K" + String1 % string + char -> string
CoeffsRange = "H2:K10"
CoeffsRange = strcat("H2:K",String1) % or use strcat()
CoeffsRange = "H2:K10"

More Answers (0)

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!