Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find and replace | Excel Discussion (Misc queries) | |||
Find and REPLACE within a selection, or column- not entire sheet/. | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) | |||
How Can I find and replace symbols in excel data ( white square) | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |