I am having problem with replacing a particular value in excel. In excel- Column4 contains (hp,hp,hp,dell,dell,dell,nokia,sony,sony) I need to replace a particular cell value. for e.g. I need to replace the sony with ericsson. I am using for each loop and if condition to extract the data. how ca…

Hi @Pavannaik , Use " For Each Row " Activity. then use "Get Row Item " Activity inside " For Each Row " Activity. Specify the column name , or column index to get the data of that column of that row. Then put it in a variable and check if it matches Sony. if condition is yes , then use writ…

How to replace particular cell value in excel

Help

Pavannaik (Pavan) December 18, 2017, 2:40pm 3

Thanks it worked fine

To replace multiple strings in an excel cell

Topic		Replies	Views
How to write in a particular excel cell Studio	2	1502	July 13, 2020
Replace value in Excel Help	3	2898	December 2, 2019
How to pass the specific cell value in 'Find/Replace Value' Activity Automation Starter excel , studio , question , activities_panel	4	909	July 1, 2022
Find and replace string in whole excel file Help	5	3717	December 2, 2019
How to find and replace a value in excel Help datatable , excel , activities , question , data_manipulation	5	9236	February 11, 2020

Most Active Users - Yesterday
V_Roboto_V
ashokkarale
aikaterini.karakasidi
sonaliaggarwal47
Nguyen_Van_Luong1
Anil_G
nisargkadam23
mohamed.saty2012
adilhassanpost
More details...

How to replace particular cell value in excel

Related topics