Man illustrationFlower illustration

Find and replace

Estimated reading: 2 minutes 38 views

“Find and replace” activity is used to find a specific word or phrase within a MS Excel file, text, or file and then replace it with a desired word or phrase.


*Excel nameThe reference name of the MS Excel file which has already been opened or created is chosen in the dropdown.
*New dataset nameReference name of dataset which will be created
Sheet nameThe name of the sheet to work in MS Excel can be added. If not added, it is accepted as the first sheet by default.
RangeExcel sheet range from which to fetch data is written.
*Find whatString that is searched for and will be replaced.
*Replace withNew string that will be replaced with.
Note: * Fields selected with are required, others are optional.

You can use the Excel name as shown in the example.

${formatExcel}

You can use the New dataset name as shown in the example.

TestDataset

You can use the Sheet name as shown in the example.

Sheet1

You can use the Range as shown in the example.

A1:C5

You can use the Find what as shown in the example.

RPA

You can use the Replace with as shown in the example.

RobustaRPA
Share this Doc

Find and replace

Or copy link

CONTENTS
Chat Icon Close Icon