Search and replace string(S) of text...

[Addam]

ISSUE:

My users use abreviations when they type some things in.

I figured out how to use the "Substitute" function, but I can't seem to get it to replace more than one at a time example:

Field 1: We all say "TGIF" but some say "Agh". What do you say?

Field 2: We all say "Thank God it's Friday" but some say "Ahh Go HOME!". What do you say?

SETUP:

Administrators are able to enter in the acronyms in one field and what it should be in another.

FIELD 2 will then search the string and change out all the acronyms and display the correct results...

Can anyone help?

[BobWeaver]

You either have to apply the Substitute function successively, or use nested Substitutes