I have a number of stock market symbols that I need to modify. For example, I
must change: AAA.UN to AAA-UN. For some I need to modify AAA.UN to AAA-UN.TO
.. In short, I simply want to change a period to a dash and for some add
period TO . Is there a way of developing a macro to do this or use the "Find
and Replace"? I don't want to retype all the symbols - chance of errors and
would take a very long time.
Any help here would be much appreciated.
Thanks. Norm.
Bookmarks