For example, if the row contains the text "Brian 10.00 Paid", I want to end up with " 10.00 ". The search would be for several values (i.e., for Brian, Tanya, etc.). Thanks!
There's not a built-in way of doing it, but it can probably be achieved with a custom-made script. Not a simple task, though.
I am pretty green w Adobe, is there a sample of a script I might be able to start from?
Not that I'm aware of. You'll basically need to iterate over all of the words in all of the pages in the file, looking for matches to your search strings.
When you find a match you'll need to decide which part of it to redact and then create Redaction annotations using the coordinates (quads) of those words.