Help regarding inserting values in Excel

Hi Expert,
I am automating a basic stocks task.
I am copying values(Company names) from excel column, googling its stock price and pasting that price to its relevant cell beside.
But the problem i am facing is that rpa express pastes prices in excel from a cell below the desired cell.
PFA screenshot of action flow and excel result of the action flow.


Hi @karan_dave,

It happens because when you join strings in step 9, you use an empty string “csl” at the beginning. So instead of 3 values, your final list has 4.

Instead of joining and then splitting strings, you can use Expression action and directly append “tempprice” value to “comppricelist”.

1 Like

Thank you @ashapkina for the help.
It worked fine.

1 Like

Glad it helped :grinning: