MACRO FOR EXCEL
Posted on 2005-05-06
i have no excel knowlede AT ALL. i know how to cut, paste and run a macro!!
i have a spreadsheet that shows phone numbers in each row based on the month in each colum. the months are listed in the header as follows JAN - FEB FEB - MAR, ect, ect. (colums A-L) each row has a different count of numbers because the activity was different. one month i made 360 calls and another 410 calls, got it?
1. i want to run a macro or module that will delete everything but my (209) area code numbers. i have the value set at (555) 555-5555 BUT i can change it to 555-555-5555 or 5555555555. it dont matter to me whatever makes the macro eaiser if anything.
2. and if at all possible i would like to run something that will "delete, clear or remove" duplicates.
thank you in advance, if you could just give me the macro all i plan to do is cut/paste cause i dont know much more ;o)