Change text in excel

[fairymemay (noona)]

I want to change text (in font red column A to in font red column B)
condition : if line in column A = “home name” and in next line found address change address to “home address”.
if line in column A = “office name” and next line if found address change address to “office address”.

Please guide me.

[Pratik_Wavhal]

Hi @fairymemay

Below is the workflow for the same :-
MainPratik.xaml (12.6 KB)
New Microsoft Excel Worksheet.xlsx (9.3 KB)

Input :-

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal