I am currently using a macro that eliminates every occurrence where a colon, blank space or zero is the very first character in any cell within columns A,C and E. The problem I am having is that I now need to have formulas in those columns to perform other functions as well and when I run the...