Klartigue
09-01-2011, 06:30 AM
In column E of a spreadsheet, there is a list of cusips followed by the word "muni". How do I write a macro so column E only dispalys the cusips and not the word "muni"
For example colum E currently looks as like:
346843FD Muni346843FD Muni812643DS Muni812643DS Muni5218402K Muni5218402K Muni4813043F Muni4813043F Muni
How do i write a macro to get rid of the word "muni"
Thanks!
For example colum E currently looks as like:
346843FD Muni346843FD Muni812643DS Muni812643DS Muni5218402K Muni5218402K Muni4813043F Muni4813043F Muni
How do i write a macro to get rid of the word "muni"
Thanks!