How to add text in all rows (Excel)

Add text all rows in column B

Now data in excel as below.

I want add text _AA extend text original as below.

Please guide me about it.

Hi @fairymemay

You can try to give condition like

Excel application scope → Give excel path

Read range Activity → Enter the sheet name

Create an out datatable in the properties panel (DTOutput)

Use For each row in Datatable

Use Assign activity

LHS - Row(“LOT)
RHS - Row(“LOT”).Tostring+”_AA"

Use Write range activity

Hope it will work


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.