Hello everyone, I apologize if this is not the right place to put this question. I am very new to this application, and don’t really know where to start in terms of documentation or what to try. I am working on a game, and wish to convert all numbers to cells with “gp” in them with a simple equation, let’s say, multiply the values by 0.2.

How does one convert selected data based on a particular string within the data? Thank you for your help and insight!

Ex.: (yes it’s D&D)

|Spellbook|50 gp|3 lb.|

|Spikes, iron (10)|1 gp|5 lb.|

|Spyglass|1,000 gp|1 lb.|

|Tent, two-person|2 gp|20 lb.|

|Tinderbox|5 sp|1 lb.|

|Torch|1 cp|1 lb.|

|Vial|1 gp|—|

|Waterskin|2 sp|5 lb.|

|Whetstone|1 cp|1 lb|