How can i find and replace with one excel to another for multiple column.

Find and Replace instead to use multiple times can we have one tool that do find and replace in one go.

Workflow

Accepted answers

Sure, see attached.

Please mark as a solution if this helped you.

Best,

Gustavo

MultipleColumnReplacementExample.yxmd

All comments

Hello @rohit782192

One suggestion is to use the Transpose tool before applying the Find Replace, in that way, you can replace multiple columns using just one Find Replace tool.

Best,

Gustavo.

ANY EXAMPLE

Sure, see attached.

Please mark as a solution if this helped you.

Best,

Gustavo

MultipleColumnReplacementExample.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703