Variables inside string from excel cell

[andres.enriquez]

Hello people!
Im struggling to make the system take the variables I put inside a string from an excel cell as a variable and not as a string literal.
I show you the excel sheet:

“this is number A”+NROA+“this is number B:”+NROB

I have NROA and NROB variables declared and its values.
NROA: “1123236224”
NROB: “1128980455”

My objective is to get something like this:
this is number A 1123236224 this is number B 1128980455
But what I obtain is this
“this is number A”+NROA+“this is number B:”+NROB

Should I use “Split”? In that case, how should I implement it?
Any suggestions?

Thanks in advance
Cheers!

[efelantti]

“this is number A”+NROA+“this is number B:”+NROB

One option - set this value to the cell in Excel:

this is number A: {0} this is number B: {1}

Then in an assign activity:

formattedValue = String.Format(cellValue, NROA, NROB)

where cellValue is the Excel cell text.

[efelantti]

Another way could be to use Excel formulas, as I see you have the variables in another columns on the same sheet?

[andres.enriquez]

This one worked for me!
Thanks a lot efelantti
Cheers!