How Do I Perform a Complex Find and Replace Action In Numbers?

What is the best method (formula or javascript) for looking at a range of cells (specifically, an entire column), checking to see if there is a text string within each cell that meats certain criteria, and then replacing all of the text within each cell with my specific text. I need to replace text from […]