Find and Replace within a row

[StefanvanWyk]

Good Day,

The solution to this might be very simple. However, I have looked at a couple of options and could not find one.

I need to find a certain word within my table rows and replace it. What would be the best way to go about this?

[atcodedog05]

Hi @StefanvanWyk 

Can you provide some sample data and expected output. So that we can help you out better 🙂

[StefanvanWyk]

Sure, thank you.

I have attached a simplified version of the sample data.

Basically, we have datasets containing all our businesses. However, we changed the name of the business. Now for comparable figures, we need to change all the previous records from the old name to the new business name.

Within the Sample Data, the one that I am trying to change is Roto N to N Labels.

[atcodedog05 · Accepted solution]

Hi @StefanvanWyk 

You can do something like this.

Input:

Reference containing changes

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@StefanvanWyk 
There are a couple of ways, but I prefer the Find and Replace Tool considering you may have more that one to find and replace.
Appreciate you would mark it as accepted if you find it works for you.

[StefanvanWyk]

Thank you so much for the assistance.

It worked!😊

[Qiu]

@atcodedog05 
You are too fast!

[atcodedog05]

Happy to help 🙂 @StefanvanWyk 

Cheers and Happy Analyzing 😀

[Qiu]

@StefanvanWyk 
Warm note, multiple accept is allowed here😁

[Qiu]

@StefanvanWyk 
thank you so much!