Creating Rules for a Table

Very simply question I would imagine but for some reason its not coming to me. How can I create a rule for a table that finds a specified word and replaces it with another such that the rule would continue to apply to the table even when a new record (or row) is added. There has to be a simple way to do this without a macro.

Hi wagstaffjh

Welcome to the forum.

Would this word be in the same position, or could it be in any column, in any position? If you do not want to use a macro, could you use (Ctrl+h find and replace)?

Regards
Alastair

Say for instance a column in the table is "College Name." I need a rule that looks at the every cell in that column and when there is "Trident Tech CLG Palmer" change it to "Trident Technical College"

The reason for this is because they are the same school, just can be listed as either of those two names on the service I am getting all of the student records from.