Excel/VBA – Manipulating Strings

I want to take a string, ex. (“Workbook1!$U$56”), and change that “U” to a “Z”. Then I want to append the new string onto the end of the old string. Can any one help me?