How do I input a variable into a string?

I am currently working on a project that takes weather data and crates a histogramm based on it. Data is structured in an Excel notebook with every month's data being in it's own sheet. The code below shows how the programm calls the data from the Excel sheet and builds the histogramm. However, i am having trouble with calling data from specific rows from the sheet. I need to change the x'es in 'Bx:Yx' to the lv variable from my code. What are the ways of doing that?

lv=get(h_list,'Value')+1 %date

mv=d(get(h_popup,'Value')) %month

Assimuudid=readmatrix("Andmed.xlsx","Sheet",(mv),'Range','Bx:Yx') %the data

theta=Assimuudid

radio_ryhm_callback %function that creates the histogramm

Answer 1

[Stephen23]

lv = 3; % example value
"B"+lv+":Y"+lv

ans = "B3:Y3"

sprintf('B%u:Y%u',lv,lv)

ans = 'B3:Y3'