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

[rohit782192]

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

[perin]

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.

[rohit782192]

ANY EXAMPLE

[perin · Accepted solution]

Sure, see attached.

Please mark as a solution if this helped you.

Best,

Gustavo