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?
Solved! Go to Solution.
Can you provide some sample data and expected output. So that we can help you out better 🙂
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.
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 😀👍
@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.
Thank you so much for the assistance.
It worked!😊
@atcodedog05
You are too fast!
@StefanvanWyk
Warm note, multiple accept is allowed here😁
@StefanvanWyk
thank you so much!