how to use string in eval function

I'd like to use eval for this expression: sheet ='p1_Q1_test';

It works for num2str(x) but does not work for string y.

How can I use the string 'y' correctly in eval?

x = 1;
y = 'Q1';
eval(['sheet =p' num2str(x) '_' y '_final']);
A = xlsread('E:\myfolder\datasheet.xlsx', sheet);

error:
Undefined function or variable 'p1_Q1_test'.

Answer 1

[KSSV]

x = 1;
y = 'Q1';
sheet =strcat('P',num2str(x),'_',y,'_final')

sheet = 'P1_Q1_final'

Answer 2

[Stephen23]

"I'd like to use eval for this expression: sheet ='p1_Q1_test';"

Why write such complex code?

x = 1;
y = 'Q1';
sheet = ['p',num2str(x),'_',y,'_final']

sheet = 'p1_Q1_final'

or even better using SPRINTF:

sheet = sprintf('p%d_%s_final',x,y)

sheet = 'p1_Q1_final'

[Ham Man]

Great thanks. It works nice!

[Image Analyst]

@Ham Man then please click the "Accept this answer" link to award @Stephen23 "reputation points". He'll appreciate it. Thanks in advance. 🙂