How to add text in all rows (Excel)

Help Activities
, ,
1

Add text all rows in column B

Now data in excel as below.
image

I want add text _AA extend text original as below.
image

Please guide me about it.

2

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
image

Use Assign activity

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

Use Write range activity

Hope it will work

Regards
Gokul

1 Like
3

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