Mutual Replacement

[Krista]

I'm trying to create a Macro to translate a code some of my friends created, and I can't figure out how to change (to use an example) "A"s to "Z" as well as all "Z"s to "A".
I've been using the Find and Replace function, but of course, once I've got all the initial "A"s changed to "Z", I'm left with all "Z"s, which are in turn all changed to "A" when I use the function again...To put it another way, I would be trying to replace "JAZZ" to "JZAA", but I'm just ending up with "JAAA"..

Is there any way I can make the letters replace eachother mutually?

 

[user]

Replace all A by "~" for exemple and Z by "§" then replace all "§" by A
and "~" by Z...

Not that you asked really but will do the trick.