How to find and replace a value in excel

[mukeshkala]

On the Top of what everyone suggested - The same can be done for all values at once using UI Automation

1. Send Hotkey (ctrl + H) : this will open the Below Menu

2. Take Two Type into activities and Type values Primary 1 in Find what and Primary in Replace With

3. Click on Replace all.

4. Repeat the same for Primary 2 and Secondary.

OR

use BalaReva Custom Excel Activity . Below is link for Same

BalaReva.Excel.Activities Continue

I continue the above thread here due the length of the thread. Hi Friends, I have included a new activity called “Find Replace”. Using this activity can find and replace the text into the excel. It has the find option like below Part Match against any part of the search text Whole Match against the whole of the search text Namespace [image] Properties [image] Samples :FindReplace.zip (7.8 KB) Note : The sample has been developed by the version of CE 18.3. If you get an…

–
Mukesh