hi @TerryS
You're for loop seems not as you want.
Exceldata is a datable and your currentitem is a column , so iterate through each cell of your Currentitem and then use replace action
or else Do this:-
1)Search for each keyword in your text file, then
2)check if it is available in Column A using for loop (iterating through each cell in the column)
3) if it is found, get the row no and then use your replace action and mention column B with row no.
PAD does not have enough excel actions to work, but you can use 4 line VBA code to achieve this.
Thanks
AR
Please consider marking my post as a solution! to guide others, if this helps.
