the easiest thing for you to do would be to use (in the toolbar):
Record new macro
it will let you name the macro you are going to record (see note below
about where to store it).
then do exactly what you want to do - edit/replace all of the strings.
then stop the macro recorder.
voila! you have a macro.
to use it again, go to:
and you will find a list of available macros. the one you just
recorded will be listed there. if you choose that macro, it will run
again (but will probably not show it doing anything because you just
did it - it's not going to find any text to replace until you add more
note - if you want this to work on multiple workbooks, then when you
are naming the macro, tell it to save it in the personal.xls. then it
will be available in every workbook you open.
hope this helps